It really helps if you post the SQL you are using and an example of the data
in the table and the result you want to retrieve. Otherwise we have no clue
what "does not work properly" means and no way to discover what you've done
to cause the "does not work properly."
"iso" <ismailozyigit@xxxxxxxxxxx> wrote in message
news:e%237Ed9S6FHA.1000@xxxxxxxxxxxxxxxxxxxxxxx > ....."Is there any problem with GROUP BY if I use OLEDB". it seems like
> it does not work properly. so should I cchange my code?
Re: Which identity? ... > Some postings I read suggested using MAXto retrieve the inserted record ... > each of these 3 SQL features?... Another way to do it if using the .AddNew method on a Jet based ADO...Dim rsTest As ADODB.Recordset ... (microsoft.public.access.queries)
Re: White Paper on How MSAccess interacts with SQL Server Back End ... these keys to retrieve the other fields from the tables by group of 10 rows. ... or with VBA functions that Access cannot translate directly into T-SQL ...Sylvain Lafontaine, ing. ... my SQL 2000 db using ACC2003 as the front end via linked tables. ... (microsoft.public.access.adp.sqlserver)
Re: Parameters Question ... you can get it to work in OLEDB for SQL by ... > But as I said in my post, I have never been able to get named parameters... > work in OLEDB for SQL Server.... (microsoft.public.dotnet.framework.adonet)
Re: Error adding command properties for stored procedure call ... however it closely resembles the OleDb samples provided by Microsoft. ...ICommandText interfaces to call a stored procedure,... Links for SQL Server Books Online:... (microsoft.public.data.oledb)
Re: VFP ODBC ... to 'get to the data file' and if yer not using the right version of an oleDB... driver set for VFP.... I know you don't have v9 - but if I had to sling data into a sql server - ... Save non-verified file DSN?... (microsoft.public.fox.helpwanted)
