How do you do it? Tried everything. Help.
Subject: Insert statement to sql server 2000
You’ll need to be much more specific. What constitutes “everything?” How are you building your SQL statement? What error messges are you getting, and at what point? Post code!
Subject: RE: Insert statement to sql server 2000
sql$=“insert into pohdr(ponbr, poamt, pottl) values (001,224.96,100)”
we have also tried pulling a result set and adding a row to the result set and again we get no error but the statement is not executed
it is a system dsn to sql server 2000
Subject: RE: Insert statement to sql server 2000
if anyone has an example of what works please share.
Subject: RE: Insert statement to sql server 2000
You’re still not giving us nearly enough to work with. Again, what error messages are you getting (if any) and at what point in your code are they popping up? Are you sure this is a valid query for SQL Server? From what you’ve posted, the problem could be just about anything. In addition to the questions above, we’ll probably need to see the complete code for what you’re trying to do.