SQLEXEC(SELECT * FROM TABLE) fails

> >
> > Sir,
> > The database we are connecting is MSAccess. So CTOD() won't work. There are rules for Union-ing the tables - all f4 should be same type. We can do it all in a single query, but the result fields are returned as 'Memo' if we use any of the legal functions.
> > I request for an Expert opinion -
> > Is there any difference in querying the above tables one after another then Union-ing the same and using one single query. What’s actually happening behind the scene?. Which is the safe way?
> > With Regards,
> > Biju Thomas
>
> Biju
>
> Access DB? You have my heartfelt sympathy :)
>
> OK do it in a series of queryies. You will probably have to use a series of queryies. You can pull the date field in as a date (in your earlier query) and then convert it to string in the UNION query.
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)

Sir,
What's wrong with Access.
With Regards,
Biju Thomas

ENTIRE THREAD

SQLEXEC(SELECT * FROM TABLE) fails Posted by Ilya Rabyy @ 3/10/2008 7:16:48 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Eric den Doop @ 3/10/2008 7:24:45 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ilya Rabyy @ 3/10/2008 7:40:51 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Borislav Borissov @ 3/10/2008 7:24:23 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ilya Rabyy @ 3/10/2008 7:53:31 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Borislav Borissov @ 3/10/2008 7:58:12 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ilya Rabyy @ 3/10/2008 8:20:16 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Borislav Borissov @ 3/10/2008 8:22:44 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Andy Kramek @ 3/10/2008 10:26:55 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ilya Rabyy @ 3/10/2008 11:50:27 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/10/2008 8:26:17 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Borislav Borissov @ 3/10/2008 8:29:38 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Andy Kramek @ 3/10/2008 10:25:09 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ilya Rabyy @ 3/10/2008 10:45:08 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/11/2008 1:13:48 AM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Jim Booth @ 3/11/2008 10:24:26 AM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ilya Rabyy @ 3/11/2008 3:20:12 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Cetin Basoz @ 3/11/2008 11:11:16 AM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ilya Rabyy @ 3/11/2008 3:23:03 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Biju Thomas @ 3/15/2008 4:51:48 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Cetin Basoz @ 3/15/2008 5:06:26 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Biju Thomas @ 3/15/2008 5:21:10 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Cetin Basoz @ 3/15/2008 5:29:11 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/15/2008 5:36:33 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Cetin Basoz @ 3/15/2008 8:52:36 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/15/2008 9:19:56 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Cetin Basoz @ 3/16/2008 10:33:39 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Mike Yearwood @ 3/17/2008 3:30:41 AM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Cetin Basoz @ 3/17/2008 12:00:16 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by tushar @ 3/16/2008 3:17:20 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/16/2008 3:47:04 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by tushar @ 3/16/2008 3:58:44 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/16/2008 4:16:26 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by tushar @ 3/16/2008 4:32:14 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Mike Yearwood @ 3/16/2008 4:49:16 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Mike Yearwood @ 3/16/2008 4:52:23 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/16/2008 5:21:50 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Mike Yearwood @ 3/16/2008 5:53:50 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/16/2008 7:12:55 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Mike Yearwood @ 3/16/2008 7:20:56 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by tushar @ 3/16/2008 5:54:14 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Cetin Basoz @ 3/16/2008 10:34:40 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/17/2008 3:23:37 AM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Cetin Basoz @ 3/17/2008 12:03:33 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by tushar @ 3/17/2008 6:18:21 AM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Cetin Basoz @ 3/17/2008 12:20:16 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by tushar @ 3/17/2008 1:56:44 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Biju Thomas @ 3/16/2008 10:43:41 AM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/16/2008 12:03:13 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Biju Thomas @ 3/17/2008 3:42:19 AM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/17/2008 11:52:41 AM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Biju Thomas @ 3/17/2008 4:26:33 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ken Murphy @ 3/17/2008 5:33:53 PM

RE: SQLEXEC(SELECT * FROM TABLE) fails Posted by Ilya Rabyy @ 3/17/2008 8:34:05 PM

RE: SQLEXEC(SELECT * FROM TABLE) FAILS