Search results for query: *

Boyz & Girlz, I'm getting a "General reporting engine error" when running a report with a date range. Runs fine w/o the date range. Any ideas? tnx, doug

Savissimo, Looks like you were on the right track when I stumbled upon the answer. The doco is not really clear that the format command can be used in this mannor but it works. doug

OK, I figured it out... format strSQL as "Select * from micros.Barcode_def where barcode = " , strBarcode Code is not really on two lines. As you all know the Micros SIM doco is best used to clean up after yourself in the little programmer's room. doug

doco clearely states that only RELATIONAL operator are allowed on strings. So now how do I query the DB for a specific barcode? select * from micros.barcode_def where barcode = '7331048100' anyone? doug

Perhaps I should make it clear that my code is attempting to concatenate a string variable to the end of a string. This is not a user input command. tnx, doug

savissimo, your solution retuns error "Expected end of line (,)" Doug

trying to create SQL command from user input... strSQL = "Select * from micros.barcode_def where barcode = " + "'" + intBarcode + "'" Receiving error "No ops on strings" does this mean we cannot concatenate strings in ISL? Tnx, Doug

I am trying to query the database for info surrounding a specific barcode... Select * from micros.barcode_def where barcode = '7331048109' I am setting the sql command string like this NOTE: strBarcode is user input from POS terminal. strSQL = "Select * from micros.barocode_def where...