> -----Original Message-----
> From: Andre Schild [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 05, 2001 11:20 AM
> To: [EMAIL PROTECTED]
> Subject: Antw: Torque/Sybase updates
>
>
> Hello,
>
> what sybase database are you using ? ASE or ASA ?
> We use ASA (Adaptive Server Anywhere / previously SQL
> Anywhere), the small brother of ASE
We are using ASE 11.x and quickly will be switching to ASE 12.x
> Is it possible, that we need separate definitions to distinct them ?
I hope not...
> >*) In the sql templates for Sybase, switched the ; to GO
> since we have
> > problems with this and it is standard in isql to use GO.
> When using GO in ISQL, when a error shows up, it's (almost)
> always on line 1, since this is the first line after the GO statement)
> When we use ; to send the commands to the DB, then we see (in
> case of errors) the real line number in the ISQL message,
> it's just simpler to debug.
> For ASA ; and GO both work, so if ; gives troubles with ASE,
> a switch to GO is ok.
isql has a command-line for switching the command-end charater, but since
everyone here is used to GO's it was just easier.
sqsh has trouble with the generated sql from torque, but I didn't really dig
into it much since it worked with OpenClient's isql.
> >*) Updated some types in db.props for Sybase
> Is the original DATE intended to represent a date WITH time ?
> In this case your DATETIME is correct, otherwise it would
> relay only be DATE
Hmm, I see only timestamp, datetime, and smalldatetime as types in 11.x
DATETIME was what we've always used...
> The other changes are correct, and work (at least) from ASA 6.0
>
>
> Andre.
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
>
------------------------------------------------------------------------
This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
