|
Home > Archive > SQL Anywhere Mobile > November 2005 > Flag 'row inserted'
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Flag 'row inserted'
|
|
| Fantom 2005-11-24, 7:23 am |
| Hi
In example in upload_insert is :
INSERT INTO Customer( cust_id, name, rep_id, active ) VALUES (?,?,?,1 )
May i change this that :
1) in columns definition 'active' is default 1
2) and write this INSERT INTO Customer(cust_id, name, rep_id) VALUES (?,?,?)
This is works ok in consolidate database ?
Fantom
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-11-24, 11:23 am |
| Yes, this should be fine, and is actually a better idea IMHO. Now, if you
ever want to change the default value for the active column, you only need
to change it in the database, and not in the database and in the
synchronization scripts.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"
"Fantom" <szczukot@skasujto.poczta.onet.pl> wrote in message
news:4385b990@forums
-1-dub...
> Hi
> In example in upload_insert is :
> INSERT INTO Customer( cust_id, name, rep_id, active ) VALUES (?,?,?,1 )
> May i change this that :
> 1) in columns definition 'active' is default 1
> 2) and write this INSERT INTO Customer(cust_id, name, rep_id) VALUES
(?,?,?)
>
> This is works ok in consolidate database ?
>
> Fantom
>
|
|
|
|
|