Link to home
Start Free TrialLog in
Avatar of Michael Dean
Michael DeanFlag for United States of America

asked on

Syntax in SQL

I am trying to execute a procedure from a form and syntax looks right but the table is not being updated.

Here is the syntax


Dim strinsertSQL As String
           strinsertSQL = "Insert into tblAwaitingRecords ([PeerSent], [InvoiceID], [datesent] values (-1, & me.InvoiceID, date (),);"
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

This is assuming InvoiceID is numeric and not Text data type.
  strinsertSQL = "Insert into tblAwaitingRecords ([PeerSent], [InvoiceID], [datesent] values (-1," & me.InvoiceID & ", date ())"

Open in new window

SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Michael Dean

ASKER

oh ok, well it is a number in the table and still nothing gets written to the table
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you guys!  You are the best!