Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Statement Charge Insert statement fails |
Author |
Message |
|
Posted : 2008-01-17 07:30:50 |
I am trying to put an entry onto customer statements. but it fails. What am I missing??? insert into charge(CustomerRefListID,ItemRefListID,ItemRefFullName,Amount,TxnDate,RefNumber)values ('80000004-1194374780','80000001-1199734285','WB', 33.22,'2008/1/16','5099');
are there any other tables that I need to update for this activity? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-17 13:30:30 |
Sorry you didn't say what the error was, try:
insert into charge (CustomerRefListID,ItemRefListID,Amount,TxnDate,RefNumber) values ('80000004-1194374780','80000001-1199734285',33.22,{d'2008-01-16'},'5099'); |
|
|
|
|
Posted : 2008-01-18 05:15:49 |
I'm sorry I forgot the error, but I made the change you suggested, here is my string
insert into charge(CustomerRefListID,ItemRefListID,Amount,TxnDate,RefNumber)values ('80000004-1194374780','80000001-1199734285', 33.22,'2008/1/17','5120')
I am getting this error:
[QODBC]Invalid Operand for operator:<assignment> |
|
|
|
|
Posted : 2008-01-18 06:20:20 |
Ok, I missed the date part... so I fixed it to this and now I get a different error:
insert into charge(CustomerRefListID,ItemRefListID,Amount,TxnDate,RefNumber)values ('80000004-1194374780','80000001-1199734285', 33.22,{d'2008-1-17'},'5135')
now I get:
[QODBC] expected lexical element not found:<identifier> |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-18 09:06:07 |
You don't seem to like following instructions. Try:
insert into charge (CustomerRefListID,ItemRefListID,Amount,TxnDate,RefNumber) values ('80000004-1194374780','80000001-1199734285', 33.22, {d'2008-01-17'},'5135')
Dates are {d'YYYY-MM-DD'} |
|
|
|
|
Posted : 2008-01-20 03:41:39 |
Tom, Thanks I fixed the date string and that worked great.
I am trying to pull all the items setup in the item file I use this string:
select * from Item order by fullname
I am getting 2 errors:
Data provider or other service returned an E_FAIL status
and
Item cannot be found in the collection corresponding to the requested name or ordinal.
By the way, thiscommand returns the proper data set if I use the VBdemo
Thanks, Mr. Fitz |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-20 13:43:33 |
Sorry, your image failed to upload, please explain in a little more what you are doing here, the SQL statement is fine. A E_Fail message normally has something to do with cursors or nulls.
See: How do I upload images to my forum post? |
|
|
|
|