|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
|
| Problem with inserts using TERMS and a VBDEMO bug |
| Author |
Message |
|
|
| Posted : 2009-09-25 09:02:44 |
I am trying to do a test insert with this:
INSERT INTO "Terms" ("Name", "StdDueDays", "StdDiscountDays", "StdDiscountPct", "Type") VALUES ("TEST", 14, 16, 1, "StandardTerms")
error: [QODBC] Column not found: TEST
Help. (this is also a weird description of an error where TEST is a value, not a field....)
------------------
Also weird:
if you do "Select * from terms" before anything, then you try my query the one on the top, after you get the QODBC error, try clicking at any of the fields left from select query with the right mouse... application quits due to a bug... |
|
|
|
|
|
| Posted : 2009-09-25 13:18:46 |
The Terms table is a read-only table as can be seen by doing:
sp_columns terms
For INSERTs, the Text Values have single quotes around them, not double quotes, ie:-
INSERT INTO "customer" ("Name","LastName","FirstName","BillAddressAddr1",
"BillAddressAddr2","BillAddressCity","BillAddressState","BillAddressPostalcode")
values('Zuniga, Daphne','Zuniga','Daphne','Daphne Zuniga','561 W 4th
St.','Carlsbad','CA','92009') |
|
|
|
|
|
| Posted : 2009-09-26 01:03:04 |
Why would this table be read only?
Is there other way to insert Terms? |
|
|
|
|
|
| Posted : 2009-09-26 14:52:29 |
| QODBC limitations are set by the Intuit qbXML SDK revision and version of QuickBooks you are using. You will need to use the QuickBooks UI (User Interface) to create additional TERMS. |
|
|
|
|
Copyright (c) 2006-2009
Data Access Worldwide,
Australia. This FREE self help forum website
was copied by FLEXquarters.com Limited, Hong Kong to: http://archive.qodbc.com
/forum50f5.html
without our
permission. |
The QDeveloper Forum is
dedicated to the FREE professional exchange of
information. QODBC and FlexODBC users can post support
queries, report product bugs, or simply search topics
for help. Data Access Worldwide - Asia Pacific normal office
business hours are 9am to 5pm
week
days
Australian EST with the exception of Public Holidays.
ABN: 86 544 223 459
PO Box 873,
Boronia VIC 3155 Australia
Tel: 03 9761 3644 Intl: +613 9761 3644 |
