access database connectivity

[RobertoBozzolo]

I'm happy for that!  I was wondering what could be happening but didn't know where to get my hands on.

PS If you want to reward somebody with kudos you can click on the yellow star near the user name

[Joncombat]

I blame windows!!!  Now that I have the connection running I am sure I will have more posts!

[Joncombat]

I can create a new record, update an existing record.  how do I determine if a record exists?  I have an ID (key) of lets say 12345.  what cvi sql function would I use?

[RobertoBozzolo · Accepted solution]

I'm not so fond on SQL to know a direct command, but I would try with a DBIMmediateSQL (Select * From MyTable WHERE key = '123456') followed by a DBNumberOfRecords.

[Joncombat]

ok, last question.  I am trying to delete a record with ID = 12345.  the example given in CVI is not that clear. 

my statement is DELETE FROM TABLEX WHERE ID = 12345

[RobertoBozzolo]

Unless this is a typo, the correct command should be enclosed in single quotation marks: DELETE FROM TABLEX WHERE ID = '12345'

Besides it, you could look at del_rec example that gets installed together with the sql toolkit, that shows both this method and an alternative one using tollkit commands instead.

[Joncombat]

I'm up and running.  My issue was a typo in the sql statements.  I am using variables and a Fmt() function to create the string and introduced an error.  To quote the gremlin from bugs bunny, " These blockbuster bombs don't go off unless you hit them "just" right!"

[RobertoBozzolo]

Oh yeah! SQL is particularly oversensitive to wrong semantics!