Hi!

The variable past "?" is called "parameter" for SQL command(s). When executing, all "?{variable}" are automatically replaced by real values and sent to SQL server. More, these values are replaced in a such way that you can pass really large data (megabytes) using this approach, that is limited when passing data directly as a constant. This way is very useful for saving General and large Memo field data.

>Hi,
>
>If I want to insert a general field (in SPT) to an image field in SQL Serve, I can issue:
>
>SQLEXEC(lnConnect, [Insert into mytable (ImageField) values (?MyCursor.GeneralField)])
>
>Question - what is the "?" doing exactly here? Is there a function equivelant of it if I wanted to concatenate the SQL String myself?
>
>TIA,