SQL Anywhere Mobile - Truncate Table

Author

Truncate Table

Asirteheio

2005-07-27, 3:26 am

Hi all

It will be error occurs if the primary key have datetime
column~
How to do?

Error: [-10002] ODBC: [Microsoft][ODBC SQL Server
Driver]Restricted data type attribute violation (ODBC State
= 07006, Native error code = 0, Column or parameter #2)

MS-SQL 2000
PB 1.5.2
ASA 9.0.2

Thanks
Asirteheio

David Fishburn

2005-07-27, 7:27 am

Asirteheio wrote in news:42e73331.3c77.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

A> It will be error occurs if the primary key have datetime
A> column~
A> How to do?
A>
A> Error: [-10002] ODBC: [Microsoft][ODBC SQL Server
A> Driver]Restricted data type attribute violation (ODBC State
A> = 07006, Native error code = 0, Column or parameter #2)
A>
A> MS-SQL 2000
A> PB 1.5.2
A> ASA 9.0.2

Please start ML using -v+ -ot ml.txt and post the full output of a
synchronization.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links