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
|
|
Cannot Update BirthDate column |
Author |
Message |
|
Posted : 2008-11-05 03:50:16 |
I have been successfully able to update or insert other fileds in the Employee table expect BirthDate. The following SQL when run inserts all fileds except BirthDate. The column appears NULL after insert. Updating the same row runs successfully but updates it to NULL.
INSERT INTO Employee (IsActive, FirstName, MiddleName, LastName,EmployeeAddressAddr1,EmployeeAddressAddr2, EmployeeAddressCity, EmployeeAddressState,EmployeeAddressPostalCode, SSN, Gender, BirthDate) VALUES(1,'Test','C','Test','22 Chester Street','PO Box 112','The Beach','CA','3155','123-45-6789','Female',{d'1953-11-07'})
Thank you. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-05 14:07:42 |
I have no idea what version, country or year of QuickBooks you are running, but I just did:
INSERT INTO Employee (IsActive, FirstName, MiddleName, LastName, EmployeeAddressAddr1,EmployeeAddressAddr2, EmployeeAddressCity, EmployeeAddressState,EmployeeAddressPostalCode, SSN, Gender, BirthDate) VALUES(1,'Test','C','Test','22 Chester Street','PO Box 112','The Beach', 'CA','3155','123-45-6789','Female',{d'1953-11-07'})
and got:
|
|
|
|
|
Posted : 2008-11-06 06:17:29 |
I am using QuickBooks Premier - Multicurrency Edition Canadian Edition 2007
Screenshot below:
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-06 07:41:30 |
Sorry, that's a bug in the Canadian edition of QuickBooks that's been fixed in non-multi-currency version of QuickBooks 2008:-
QBCA001404: BirthDate is not returned for EmployeeQuery. Both BirthDate and SIN is not showing in QBUI.
See: Two Versions of Canadian QuickBooks 2008 |
|
|
|
|
Posted : 2008-11-06 10:18:57 |
Thanks for your reply. Is there an ETA for the fix for this issue?
Thanks.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-06 11:21:44 |
Intuit have already fixed the bug in the non-multi-currency version of the Canadian Edition of QuickBooks 2008. |
|
|
|
|