Re: [sqlite] Equivalent syntax in sqlite

cas...@activenetwerx.com > wrote: > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On > Behalf Of David Raymond > Sent: Wednesday, April 26, 2017 3:00 PM > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Subject: Re: [sqlit

Re: [sqlite] Equivalent syntax in sqlite

From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of David Raymond Sent: Wednesday, April 26, 2017 3:00 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Equivalent syntax in sqlite > With the comment that t

Re: [sqlite] Equivalent syntax in sqlite

4:46 PM To: SQLite mailing list Subject: Re: [sqlite] Equivalent syntax in sqlite On 26 Apr 2017, at 9:42pm, Joseph L. Casale <jcas...@activenetwerx.com> wrote: > Whats the trick with SQLites working set to format a single statement with > parameters > where if a row exists for a

Re: [sqlite] Equivalent syntax in sqlite

On 26 Apr 2017, at 9:42pm, Joseph L. Casale wrote: > Whats the trick with SQLites working set to format a single statement with > parameters > where if a row exists for a given criteria, returns its Id, otherwise insert > and return the > last_insert_rowid()? It

Re: [sqlite] Equivalent syntax?

"Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > Is cast documented on the sqlite website? I couldn't find it. > http://www.sqlite.org/lang_expr.html -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe,

RE: [sqlite] Equivalent syntax?

Thanks. Unfortunately my background is sybase and that's anything but standard :-( -Original Message- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 6:52 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? On Wed, 31 Jan 2007 17:30:29

RE: [sqlite] Equivalent syntax?

Thanks, somehow I had missed it. -Original Message- From: Nicolas Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 6:43 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? On Wed, Jan 31, 2007 at 06:31:20PM -0500, Anderson, James H (IT) wrote

Re: [sqlite] Equivalent syntax?

On Wed, 31 Jan 2007 17:30:29 -0500, you wrote: >BTW, what is the concatenation operator? Standard SQL: string || string -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Equivalent syntax?

On Wed, 31 Jan 2007 18:31:20 -0500, you wrote: >Is cast documented on the sqlite website? I couldn't find it. http://www.sqlite.org/lang_expr.html -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL

Re: [sqlite] Equivalent syntax?

On 1/31/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: Is cast documented on the sqlite website? I couldn't find it. .. http://www.sqlite.org/lang_expr.html -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source

Re: [sqlite] Equivalent syntax?

On Wed, Jan 31, 2007 at 06:31:20PM -0500, Anderson, James H (IT) wrote: > Is cast documented on the sqlite website? I couldn't find it. http://www.sqlite.org/ Click on 'syntax', click on 'expression', arrive at: http://www.sqlite.org/lang_expr.html

RE: [sqlite] Equivalent syntax?

Is cast documented on the sqlite website? I couldn't find it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 5:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? "Anderson, James H \(IT\)" <[EM

RE: [sqlite] Equivalent syntax?

Experimenting :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 5:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > In the case

RE: [sqlite] Equivalent syntax?

OK, thanks, I'll try that. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Wednesday, January 31, 2007 5:34 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? On 1/31/07, Anderson, James H (IT) <[EMAIL PROTEC

Re: [sqlite] Equivalent syntax?

"Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > In the case shown, for example, > > convert(char(3), NULL) CDRefIndustry, > > It creates a char(3) column, sets it to null, and names it > CDRefIndustry. > Dennis Cote's guess was mostly right then. A strict equivalent in SQLite

Re: [sqlite] Equivalent syntax?

about SELECT null AS CDRefIndustry or SELECT '' AS CDRefIndustry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 5:14 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax? "Anderson, James H \(IT\)" &

Re: [sqlite] Equivalent syntax?

On 1/31/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote: What's the equivalent sqlite syntax for sybase convert function? For example, select distinct date, CDId, CDName, CDTicket, tradeId, tapsAccount, CDBook, coalesce(CDFid,'') CDFid, CDStatus, CDTradeDate,

RE: [sqlite] Equivalent syntax?

I don't see the cast function listed in the Core Functions section of the web page... BTW, what is the concatenation operator? -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 5:21 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite

RE: [sqlite] Equivalent syntax?

@sqlite.org Subject: Re: [sqlite] Equivalent syntax? "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > What's the equivalent sqlite syntax for sybase convert function? Can you describe what the convert function in sybase does? That might help us to find the equivalent functio

Re: [sqlite] Equivalent syntax?

Anderson, James H (IT) wrote: What's the equivalent sqlite syntax for sybase convert function? For example, select distinct date, CDId, CDName, CDTicket, tradeId, tapsAccount, CDBook, coalesce(CDFid,'') CDFid, CDStatus, CDTradeDate, CDExpDate, CDNotional, CDCurr,

Re: [sqlite] Equivalent syntax?

"Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > What's the equivalent sqlite syntax for sybase convert function? Can you describe what the convert function in sybase does? That might help us to find the equivalent function in SQLite for you. -- D. Richard Hipp <[EMAIL PROTECTED]>