Valentina SQL

[Marcus Bointon]

on 16/2/03 8:53 pm, Art Peters at akpce at atlantic.net wrote:

> All:
> 
> I am having trouble with INSERT INTO when using binding.
> I have no trouble with the standard INSERT INTO statement.
> 
> What is bound or what form does it take. I have tried
> a string array, a string, etc. I haven't hit the
> correct combination yet. My reference is the
> Valentina SQL pamphlet, page 6.

I assume you're talking about field binding in V4MD. In that case, once you
have set up the bound fields, that's it. If you modify the fields, then the
records will be updated. However, this won't create new records, so you
should create your empty cursor (using recid=0), call setblank, and you
should have a new record that will take the values of your bound fields.
Part of the point of binding is so you don't have to build complex SQL - it
does it for you.

Sorry if you meant something else!

Marcus
-- 
Marcus Bointon
Synchromedia Limited: Putting you in the picture

marcus at synchromedia.co.uk | http://www.synchromedia.co.uk