Claudine: This syntax doesn't look right. Either you would use VALUES or SELECT, but not both
INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM &vfilename Karen -----Original Message----- From: Buddy Walker <[email protected]> To: rbase-l <[email protected]> Sent: Wed, Aug 1, 2018 1:03 pm Subject: RE: [RBASE-L] - Picking and Renaming Windows Files Claudine Since you have commas in the file I would think you have to load the table instead of insert. Buddy From: [email protected] <[email protected]> On Behalf Of Claudine Robbins Sent: Wednesday, August 1, 2018 1:21 PM To: [email protected] Subject: [RBASE-L] - Picking and Renaming Windows Files Hi all, I’m trying to capture multiple file names to rename them. The following code gives me the error: “ERROR-Incorrect number of values for this table (118)”. It appears I may need quotes around each value. Any easy way to do this? TIA, Claudine PLUGINS LoadFileNamePlus vFileName + |INITIAL_DIR C:\iex_x\CHRISPREP + |TITLE 'Select file' + |FULLPATH ON + |NO_CHANGE_DIR ON + |FILTER PDF Files (*.PDF)#*.PDF + |HIDE_READ_ONLY ON + |MULTISELECT ON + |SHOW_HIDDEN OFF + |ENABLE_SIZING ON + |VIEW_MODE LIST SET VAR vfilename = ( '('+.vfilename+')' ) SET ERROR MESSAGE 2058 OFF DROP TABLE `tFileName` NOCHECK SET ERROR MESSAGE 2058 ON CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40)) R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM &vfilename -ERROR- Incorrect number of values for this table ( 118) R>sho v vfilename (C:\IEX_X\CHRISPREP\ACME-54572 05-BU-0702181107AU.pdf,C:\IEX_ X\CHRISPREP\ACME-5457205-07021 81107AU.pdf,C:\IEX_X\CHRISPREP \ACME-5457205-INV-0702181107AU .pdf) -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
