I got it!! Turns out alot easier to do. The problem comes with the "where DetailNo = '%PartNo%' part of the SQL statement. When PartNo has a single quote in it, like "ABCD-5'XL" then the SQL becomes "where DetailNo = 'ABCD-5'XL' " and SQL doesn't like that. But if I replace the single quote with two...

I am trying to do a SQL query on a csv file that looks like this. Select * from %PO_File% where DetailNo = '%PartNo%' Simple right? The problem is that some of the values for PartNo have a single quote ( ' ) in it that mess up the query. So does anyone have a work around? I tried to do a StringRepla...

Thank you for your help! This is what I feared I would have to do, but I hadn't figured out how to manipulate my queried data yet to add a "blank". Next task I guess. EDIT: Turns out adding this one line makes it work. StringReplace>CsvFile,%CRLF%,%COMMA%%CRLF%,CsvFile Thanks as well for the heads u...

To get the editable column, I set the column number to one more than the data I am receiving via the query and making the StringGrid editable. I have looked at all of the variables and the data is completely cleared out, so my theory is that there is some behind the scenes memory that I can't obviou...

I have a dialog that displays queried data in a StringGrid. I have figured out how to add a column for the user to enter data into the StringGrid object that I can then save into a new CSV file. This all works great until I want to go to the next queried record. I have a "Clear" button that clears b...

That did it.

Thank you JRL!

I am having a problem with the following lines: GetDialogProperty>PartLookUpDialog,PartCode,Text,varCode GetDialogProperty>PartLookUpDialog,PartDesc,Text,varDescrip Let>PartStr=Select Products.Code, Products."Desc" From "Products" where (Products.Code Like '%varCode%%') and (Products."Desc" Like '%v...

I am trying use RegEx with the EasyPatterns Filename patterns of [Filename] and [Path] but I get the error "Path is not a valid keyword".
Is the [Filename] and [Path] not supported?

Thanks