|
Home > Archive > SQL Anywhere Mobile > April 2005 > Table order does not work
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 |
Table order does not work
|
|
|
| Hi Everyone,
I need to use the extended option tor or tableorder to
ensure a certain table that does not have an explicit
reference to a couple of other tables, is synchronized after
the tables it may reference. The problem is that the I
receive and error message when using the tableorder option.
I have checked and I do have all of the tables listed, I
tried with and with the owner prefix, with and without
spaces after the commas. Below is the publication and sync
user, followed by the relevant section of the dbmlsync
output.
ASA v9.0.2.2551.
Thanks,
xyz
CREATE PUBLICATION "DBA"."PubName" (
TABLE "DBA"." tblActionTypeItemSta
tus",
TABLE "DBA"." tblApplicationPrefer
ence",
TABLE "DBA"."tblASN",
TABLE "DBA"."tblASNItem",
TABLE "DBA"."tblASNItemDetail",
TABLE "DBA"."tblASNItemHeader",
TABLE "DBA"." tblASNItemHeaderNote
s",
TABLE "DBA"."tblBarCodeSeals",
TABLE "DBA"."tblBranch",
TABLE "DBA"."tblCentralized",
TABLE "DBA"."tblCity",
TABLE "DBA"."tblColumn",
TABLE "DBA"."tblCommodityCode",
TABLE "DBA"." tblCommodityDenomina
tion",
TABLE "DBA"."tblDenomination",
TABLE "DBA"."tblDevice",
TABLE "DBA"."tblEditTracking",
TABLE "DBA"." tblEditTrackingNotes
",
TABLE "DBA"." tblEventLocationType
Association",
TABLE "DBA"."tblEventNotes",
TABLE "DBA"."tblEvents",
TABLE "DBA"."tblExportFile",
TABLE "DBA"."tblItemDetail",
TABLE "DBA"."tblItemDetailNotes",
TABLE "DBA"."tblItemEvent",
TABLE "DBA"."tblItemHeader",
TABLE "DBA"." tblItemHistoryTypeAs
sociation",
TABLE "DBA"."tblItemType",
TABLE "DBA"."tblLocation",
TABLE "DBA"." tblLocationCommodity
Code",
TABLE "DBA"."tblLocationNotes",
TABLE "DBA"." tblLocationTimeDista
nce",
TABLE "DBA"."tblLocationType",
TABLE "DBA"."tblLookup",
TABLE "DBA"." tblMobilinkSyncStati
stics",
TABLE "DBA"."tblNotes",
TABLE "DBA"."tblProcessMonitor",
TABLE "DBA"." tblProcessMonitorIte
ms",
TABLE "DBA"." tblProcessMonitorUse
rDeviceLogIn",
TABLE "DBA"."tblReport",
TABLE "DBA"."tblRun",
TABLE "DBA"."tblRunMember",
TABLE "DBA"."tblRunMetric",
TABLE "DBA"."tblRunNotes",
TABLE "DBA"."tblRunNumber",
TABLE "DBA"."tblRunOnDevice",
TABLE "DBA"."tblRunStop",
TABLE "DBA"."tblRunStopNotes",
TABLE "DBA"." tblServiceDestinatio
n",
TABLE "DBA"." tblServiceDestinatio
nCommodityCode",
TABLE "DBA"."tblServiceType",
TABLE "DBA"."tblSignature",
TABLE "DBA"."tblSiteID",
TABLE "DBA"."tblStateProvince",
TABLE "DBA"." tblStopLocationServi
ceType",
TABLE "DBA"."tblStopTypeLocation",
TABLE "DBA"."tblTable",
TABLE "DBA"."tblTableColumn",
TABLE "DBA"."tblTruck",
TABLE "DBA"."tblUnitOfMeasure",
TABLE "DBA"."tblUser",
TABLE "DBA"."tblUserAuthRole",
TABLE "DBA"."tblUserClockTime",
TABLE "DBA"."tblUserDeviceLogIn",
TABLE "DBA"."tblUserPasswords",
TABLE "DBA"."tblVault"
);
CREATE SYNCHRONIZATION USER "DB" TYPE 'TCPIP' ADDRESS
'host=Localhost;port
=8439' OPTION lt='OFF',
tor='dba.tblTable,dba.dba.tblColumn,dba. tblStateProvince,dba
.tblSiteID
,dba.tblServiceType,dba. tblMobilinkSyncStati
stics,dba.tblTableColumn
,dba.tblCentralized,dba. tblUnitOfMeasure,dba
.tblTruck,dba.tblNotes
,dba.tblLookup,dba. tblActionTypeItemSta
tus,dba. tblApplicationPrefer
ence
,dba.tblLocationType,dba.tblItemType,dba.tblStopTypeLocation
,dba. tblStopLocationServi
ceType,dba.tblExportFile,dba.tblDenomination
,dba.tblCity,dba.tblBranch,dba.tblVault,dba.tblUser,dba.tblStopTypeLocation
,dba.tblRunNumber,dba.tblReport,dba.tblLocation,dba. tblItemHistoryTypeAs
sociation
,dba. tblEventLocationType
Association,dba.tblDevice,dba.tblCommodityCode
,dba. tblCommodityDenomina
tion,dba. tblApplicationPrefer
ence,dba. tblActionTypeItemSta
tus
,dba. tblUserPasswords,dba
. tblUserDeviceLogIn,d
ba.tblUserClockTime
,dba.tblUserAuthRole,dba. tblStopLocationServi
ceType,dba.tblRun
,dba. tblLocationTimeDista
nce,dba. tblLocationNotes,dba
. tblLocationCommodity
Code
,dba. tblCommodityDenomina
tion,dba.tblASN,dba.tblRunStop,dba. tblServiceDestinatio
n
,dba. tblServiceDestinatio
nCommodityCode,dba.tblRunOnDevice,dba.tblRunNotes
,dba.tblRunMember,dba. tblProcessMonitor,db
a.tblASNItemHeader
,dba. tblServiceDestinatio
n,dba.tblRunStopNotes,dba.tblRunMetric
,dba. tblProcessMonitorUse
rDeviceLogIn,dba.tblItemHeader,dba.tblEvents
,dba. tblASNItemHeaderNote
s,dba. tblASNItemDetail,dba
.tblSignature
,dba. tblServiceDestinatio
nCommodityCode,dba.tblItemDetail,dba.tblEventNotes
,dba.tblBarCodeSeals,dba. tblProcessMonitorIte
ms,dba.tblItemEvent
,dba. tblItemDetailNotes,d
ba.tblEditTracking,dba. tblEditTrackingNotes
,dba.tblASNItem', uo='ON';
CREATE SYNCHRONIZATION SUBSCRIPTION TO "DBA"."PubName" FOR
"DB";
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblASN.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblASNItem.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblASNItemDetail.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblASNItemHeader.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblASNItemHeaderNote
s.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblActionTypeItemSta
tus.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblApplicationPrefer
ence.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblBarCodeSeals.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblBranch.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblCentralized.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblCity.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblCommodityCode.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblCommodityDenomina
tion.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblDenomination.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblDevice.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblEditTrackingNotes
.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblEventLocationType
Association.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblEventNotes.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblEvents.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblExportFile.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblItemDetail.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblItemDetailNotes.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblItemEvent.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblItemHeader.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblItemHistoryTypeAs
sociation.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblItemType.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblLocation.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblLocationCommodity
Code.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblLocationNotes.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblLocationTimeDista
nce.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblLocationType.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblLookup.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblMobilinkSyncStati
stics.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblNotes.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblProcessMonitor.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblProcessMonitorIte
ms.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblProcessMonitorUse
rDeviceLogIn.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblReport.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblRun.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblRunMember.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblRunMetric.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblRunNotes.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblRunNumber.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblRunOnDevice.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblRunStop.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblRunStopNotes.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblServiceDestinatio
n.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblServiceDestinatio
nCommodityCode.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblServiceType.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblSignature.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblSiteID.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblStateProvince.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA. tblStopLocationServi
ceType.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblStopTypeLocation.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblTruck.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblUnitOfMeasure.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblUser.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblUserAuthRole.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblUserClockTime.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblUserDeviceLogIn.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblUserPasswords.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblVault.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblColumn.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblTable.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblTableColumn.
E. 03/16 07:58:36. TableOrder option does not mention table
DBA.tblEditTracking.
E. 03/16 07:58:36. Upload aborted at offset 0113319912
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-03-30, 9:43 am |
| We just made a bug fix recently about case sensitivity problems in the
TableOrder extended option. Without the fix (which isn't available yet ,
and no, I do not know exactly when it will be available) you'll need to
specify the DBA user in upper case for this to work.
Dbmlsync Bug Fix (QTS 382166) - tableorder extended option was treated as
case sensitive
Versions fixed: 803.5225, 901.1998, 902.3095
Customer Description:
When the tableorder extended option was specified in dbmlsync the
synchronization would fail if the tables or their owners were specified in
a different case from the one in which they were defined in the database.
This error occurred whether the database was case sensitive or not.
The tables and owners specified by this option are not always treated as
case insensitive.
--
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 "Platform Preview" and "Time Frame" to ALL
<xyz> wrote in message news:42383efc.2c87.1681692777@sybase.com...
> Hi Everyone,
>
> I need to use the extended option tor or tableorder to
> ensure a certain table that does not have an explicit
> reference to a couple of other tables, is synchronized after
> the tables it may reference. The problem is that the I
> receive and error message when using the tableorder option.
> I have checked and I do have all of the tables listed, I
> tried with and with the owner prefix, with and without
> spaces after the commas. Below is the publication and sync
> user, followed by the relevant section of the dbmlsync
> output.
>
> ASA v9.0.2.2551.
>
> Thanks,
>
> xyz
>
> CREATE PUBLICATION "DBA"."PubName" (
> TABLE "DBA"." tblActionTypeItemSta
tus",
> TABLE "DBA"." tblApplicationPrefer
ence",
> TABLE "DBA"."tblASN",
> TABLE "DBA"."tblASNItem",
> TABLE "DBA"."tblASNItemDetail",
> TABLE "DBA"."tblASNItemHeader",
> TABLE "DBA"." tblASNItemHeaderNote
s",
> TABLE "DBA"."tblBarCodeSeals",
> TABLE "DBA"."tblBranch",
> TABLE "DBA"."tblCentralized",
> TABLE "DBA"."tblCity",
> TABLE "DBA"."tblColumn",
> TABLE "DBA"."tblCommodityCode",
> TABLE "DBA"." tblCommodityDenomina
tion",
> TABLE "DBA"."tblDenomination",
> TABLE "DBA"."tblDevice",
> TABLE "DBA"."tblEditTracking",
> TABLE "DBA"." tblEditTrackingNotes
",
> TABLE "DBA"." tblEventLocationType
Association",
> TABLE "DBA"."tblEventNotes",
> TABLE "DBA"."tblEvents",
> TABLE "DBA"."tblExportFile",
> TABLE "DBA"."tblItemDetail",
> TABLE "DBA"."tblItemDetailNotes",
> TABLE "DBA"."tblItemEvent",
> TABLE "DBA"."tblItemHeader",
> TABLE "DBA"." tblItemHistoryTypeAs
sociation",
> TABLE "DBA"."tblItemType",
> TABLE "DBA"."tblLocation",
> TABLE "DBA"." tblLocationCommodity
Code",
> TABLE "DBA"."tblLocationNotes",
> TABLE "DBA"." tblLocationTimeDista
nce",
> TABLE "DBA"."tblLocationType",
> TABLE "DBA"."tblLookup",
> TABLE "DBA"." tblMobilinkSyncStati
stics",
> TABLE "DBA"."tblNotes",
> TABLE "DBA"."tblProcessMonitor",
> TABLE "DBA"." tblProcessMonitorIte
ms",
> TABLE "DBA"." tblProcessMonitorUse
rDeviceLogIn",
> TABLE "DBA"."tblReport",
> TABLE "DBA"."tblRun",
> TABLE "DBA"."tblRunMember",
> TABLE "DBA"."tblRunMetric",
> TABLE "DBA"."tblRunNotes",
> TABLE "DBA"."tblRunNumber",
> TABLE "DBA"."tblRunOnDevice",
> TABLE "DBA"."tblRunStop",
> TABLE "DBA"."tblRunStopNotes",
> TABLE "DBA"." tblServiceDestinatio
n",
> TABLE "DBA"." tblServiceDestinatio
nCommodityCode",
> TABLE "DBA"."tblServiceType",
> TABLE "DBA"."tblSignature",
> TABLE "DBA"."tblSiteID",
> TABLE "DBA"."tblStateProvince",
> TABLE "DBA"." tblStopLocationServi
ceType",
> TABLE "DBA"."tblStopTypeLocation",
> TABLE "DBA"."tblTable",
> TABLE "DBA"."tblTableColumn",
> TABLE "DBA"."tblTruck",
> TABLE "DBA"."tblUnitOfMeasure",
> TABLE "DBA"."tblUser",
> TABLE "DBA"."tblUserAuthRole",
> TABLE "DBA"."tblUserClockTime",
> TABLE "DBA"."tblUserDeviceLogIn",
> TABLE "DBA"."tblUserPasswords",
> TABLE "DBA"."tblVault"
> );
> CREATE SYNCHRONIZATION USER "DB" TYPE 'TCPIP' ADDRESS
> 'host=Localhost;port
=8439' OPTION lt='OFF',
> tor='dba.tblTable,dba.dba.tblColumn,dba. tblStateProvince,dba
.tblSiteID
> ,dba.tblServiceType,dba. tblMobilinkSyncStati
stics,dba.tblTableColumn
> ,dba.tblCentralized,dba. tblUnitOfMeasure,dba
.tblTruck,dba.tblNotes
> ,dba.tblLookup,dba. tblActionTypeItemSta
tus,dba. tblApplicationPrefer
ence
> ,dba.tblLocationType,dba.tblItemType,dba.tblStopTypeLocation
> ,dba. tblStopLocationServi
ceType,dba.tblExportFile,dba.tblDenomination
>
,dba.tblCity,dba.tblBranch,dba.tblVault,dba.tblUser,dba. tblStopTypeLocation[
color=darkred]
>[/color]
,dba.tblRunNumber,dba.tblReport,dba.tblLocation,dba. tblItemHistoryTypeAs
soci
ation
> ,dba. tblEventLocationType
Association,dba.tblDevice,dba.tblCommodityCode
>
,dba. tblCommodityDenomina
tion,dba. tblApplicationPrefer
ence,dba.tblActionType
ItemStatus
> ,dba. tblUserPasswords,dba
. tblUserDeviceLogIn,d
ba.tblUserClockTime
> ,dba.tblUserAuthRole,dba. tblStopLocationServi
ceType,dba.tblRun
>
,dba. tblLocationTimeDista
nce,dba. tblLocationNotes,dba
. tblLocationCommodity
Co
de
>
,dba. tblCommodityDenomina
tion,dba.tblASN,dba.tblRunStop,dba.tblServiceDestin
ation
> ,dba. tblServiceDestinatio
nCommodityCode,dba.tblRunOnDevice,dba.tblRunNotes
> ,dba.tblRunMember,dba. tblProcessMonitor,db
a.tblASNItemHeader
> ,dba. tblServiceDestinatio
n,dba.tblRunStopNotes,dba.tblRunMetric
> ,dba. tblProcessMonitorUse
rDeviceLogIn,dba.tblItemHeader,dba.tblEvents
> ,dba. tblASNItemHeaderNote
s,dba. tblASNItemDetail,dba
.tblSignature
>
,dba. tblServiceDestinatio
nCommodityCode,dba.tblItemDetail,dba. tblEventNotes
> ,dba.tblBarCodeSeals,dba. tblProcessMonitorIte
ms,dba.tblItemEvent
> ,dba. tblItemDetailNotes,d
ba.tblEditTracking,dba. tblEditTrackingNotes
> ,dba.tblASNItem', uo='ON';
> CREATE SYNCHRONIZATION SUBSCRIPTION TO "DBA"."PubName" FOR
> "DB";
>
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblASN.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblASNItem.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblASNItemDetail.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblASNItemHeader.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblASNItemHeaderNote
s.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblActionTypeItemSta
tus.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblApplicationPrefer
ence.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblBarCodeSeals.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblBranch.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblCentralized.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblCity.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblCommodityCode.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblCommodityDenomina
tion.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblDenomination.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblDevice.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblEditTrackingNotes
.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblEventLocationType
Association.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblEventNotes.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblEvents.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblExportFile.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblItemDetail.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblItemDetailNotes.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblItemEvent.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblItemHeader.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblItemHistoryTypeAs
sociation.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblItemType.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblLocation.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblLocationCommodity
Code.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblLocationNotes.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblLocationTimeDista
nce.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblLocationType.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblLookup.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblMobilinkSyncStati
stics.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblNotes.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblProcessMonitor.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblProcessMonitorIte
ms.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblProcessMonitorUse
rDeviceLogIn.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblReport.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblRun.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblRunMember.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblRunMetric.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblRunNotes.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblRunNumber.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblRunOnDevice.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblRunStop.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblRunStopNotes.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblServiceDestinatio
n.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblServiceDestinatio
nCommodityCode.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblServiceType.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblSignature.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblSiteID.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblStateProvince.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA. tblStopLocationServi
ceType.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblStopTypeLocation.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblTruck.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblUnitOfMeasure.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblUser.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblUserAuthRole.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblUserClockTime.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblUserDeviceLogIn.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblUserPasswords.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblVault.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblColumn.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblTable.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblTableColumn.
> E. 03/16 07:58:36. TableOrder option does not mention table
> DBA.tblEditTracking.
> E. 03/16 07:58:36. Upload aborted at offset 0113319912
| |
| David Fishburn 2005-03-30, 9:43 am |
| xyz wrote in news:42383efc.2c87.1681692777@sybase.com of
sybase.public.sqlanywhere.mobilink:
....
x> ASA v9.0.2.2551.
What happens when you leave off the owner names, and make sure there are
no spaces between the comma and the next table name.
--
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]
| |
|
| doesn't work.
> xyz wrote in news:42383efc.2c87.1681692777@sybase.com of
> sybase.public.sqlanywhere.mobilink:
>
> ...
> x> ASA v9.0.2.2551.
>
> What happens when you leave off the owner names, and make
> sure there are no spaces between the comma and the next
> table name.
>
>
> --
> 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]
>
| |
| Breck Carter [TeamSybase] 2005-04-19, 7:24 am |
| Can you check the SYSSYNC table to make sure the TableOrder string
isn't getting truncated? If it is, you can try putting it on the
command line, perhaps with an @option file.
Breck
On 18 Apr 2005 12:43:59 -0700, xyz wrote:
[color=darkred]
>doesn't work.
>
>http://ianywhere.codexchange.sybase...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|