|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 12th, 2006, 09:31 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Access Equivalent for SQLBASE Query
What would be an equivalent Access query for this SQLBase query?
select , ln.warehouse_id), co.warehouse_id ), 0, from location; Thank you. 
|
|
#2
April 13th, 2006, 01:03 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access Equivalent for SQLBASE Query
How about you write in English what the query should do, and we'll translate
to SQL? -- Steve Clark, Access MVP http://www.fmsinc.com/consulting *FREE* Access Tips: http://www.fmsinc.com/free/tips.html "shar" wrote in message ... What would be an equivalent Access query for this SQLBase query? select , ln.warehouse_id), co.warehouse_id ), 0, from location; Thank you.
|
|
#3
April 13th, 2006, 07:30 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access Equivalent for SQLBASE Query
Hi shar,
SqlBase: select @nullvalue(status, 'expired') from table MSSQL: select isnull(status,'expired') from table Access: select iif(isnull(status)=false,status,'expired') from table bye -- Giorgio Rancati [Office Access MVP] "shar" ha scritto nel messaggio ... What would be an equivalent Access query for this SQLBase query? select , ln.warehouse_id), co.warehouse_id ), 0, from location; Thank you.
|
|
#4
April 13th, 2006, 07:57 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access Equivalent for SQLBASE Query
"giorgio rancati" ha scritto nel
messaggio ... Hi shar, SqlBase: select @nullvalue(status, 'expired') from table MSSQL: select isnull(status,'expired') from table Access: select iif(isnull(status)=false,status,'expired') from table your query select iif(isnull(d.warehouse_id)=False, d.warehouse_id, iif(isnull(ln.warehouse_id)=false, ln.warehouse_id, co.warehouse_id )), 0 from ...; bye -- Giorgio Rancati [Office Access MVP]
|
|
#5
April 13th, 2006, 03:34 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access Equivalent for SQLBASE Query
Hi Giorgio,
Thank you so much for the help, it worked perfectly. Shar "giorgio rancati" wrote: "giorgio rancati" ha scritto nel messaggio ... Hi shar, SqlBase: select @nullvalue(status, 'expired') from table MSSQL: select isnull(status,'expired') from table Access: select iif(isnull(status)=false,status,'expired') from table your query select iif(isnull(d.warehouse_id)=False, d.warehouse_id, iif(isnull(ln.warehouse_id)=false, ln.warehouse_id, co.warehouse_id )), 0 from ...; bye -- Giorgio Rancati [Office Access MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Access versions and SQL | Leony | General Discussion | 12 | February 13th, 2006 08:20 PM |
| WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 01:03 PM |
| Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
| Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
| Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Linear Mode
