Recent content by DamoOz

CCLINT, whoever you are - THANK YOU

I have tried this...... How do I reference the schema.ini when opening the recordset. I have checked msdn and found some info but not exactly what I need. Do I need to use ODBC and create dsn etc Thanks in advance

I have the follow code extract where I access the contects of a text file through ADO and run a SQL query to populate a table with the text file contents. This work fine apart from some fields which the text driver is assuming is a long integer and I need to access the field as a text data type...

I have the follow code extract where I access the contects of a text file through ADO and run a SQL query to populate a table with the text file contents. This work fine apart from some fields which the text driver is assuming is a long integer and I need to access the field as a text data type...

try something like this SELECT DISTINCTROW Producer, count([producer]) as NumOfDups FROM tblClaims GROUP BY Producer HAVING count([claims]) > 1

Jim I have tried something like this but my problem is that I do not have a {table.value}. I am just keeping a count of the number of errors and I want to report if the number of errors increase or decrease by 30%. The previous function does not allow me to do a previous(count({table.error})...

Hi I have just created a program to collect error information from a switch and populate a database. I have a report to display the error information for the last 3 hours, totals treatment etc. I now require a report that only reports on errors that have a 30% increase or decrease from the...

Please help I am updating a recordset and exporting my report but the report data is not being updated. I AM using the report.DiscardSavedData but this is not working. I need to refresh this report from within code - Any suggestions??? DamoOz

Hey Mats..............Maybe nobody knows!!! Can I even copy from one recordset into another recordset if they are on different connections???.

use ..... FileCopy Source, Destination

Why not just use DHTML if it works fine???

Mats I think we have a very similar problem - you have posted a reply to my question ("a quicker way to import CSV file in ADO) in the VB - Database forum. We have to find a solution to this!! There must be a quicker way to load a table form a table in another database or CSV file etc...

Here is some modified code I have used Dim myReport As New CrystalReport1 With myReport .DiscardSavedData .ReportTitle = "Title here" .ExportOptions.FormatType = crEFTWordForWindows .ExportOptions.DiskFileName = enter path here...

Can explain a little more as I have a similar problem. Can you copy from one recordset to another even if they are from different connections. DamoOz

Paul Check the properties of cursor type in the returning recordset 0 - Forward only 1 - Keyset 2 - Dynamic 3 - Static DamoOz