> In my Unicon program I create an SQL query which is submitted to the > database server. I need to add 2 parameters, beginning/ending dates, > which I will ask of the user and insert into the "WHERE" portion of the > query. However, when I do such, I get nothing back from the server. > I've tried adding quotation marks, and that does not seem to help. I've > also tried entering the internal format of the dates into the query. > Again, without success
I do not think you can use parameters with unicon. You have to build the query on the fly and submit it. dates should be in the server format, for SQL server for example 'mm/dd/ccyy' or 'mm-dd-ccyy'. I also saw things like '#mm/dd/ccyy#' F ------------------------------------------------------- This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005 Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows Embedded(r) & Windows Mobile(tm) platforms, applications & content. Register by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click _______________________________________________ Unicon-group mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/unicon-group
