I'm working with:
MySql:
Database server: mysql-4.1.7-essential-win
ODBC driver: MyODBC-3.51.10-x86-win-32bit

I am having a problem when I try to update a Memo Field with Line Feeds and
my UPDATE statement does not seem to be working.
Some of the data that I am moving has line feeds in it, so I need to pass
Char(10)s.

I want to know how to connect to firebird database and handle data. I have
been using foxpro database till date. How do I read, replace, append data ?
Any suggestions will be greatly appreciated.

Table1 containts
A
B
C

I am facing problem in saving picture file to SQL Server Table.
In my application i am using connection string and sending queries through
program. Simple insertion/deletion queries works properly but it does not
work for picture file. I have set text(16) data type in SQL Server ...

This works:
SELECT custid, count(jobid) ;
   FROM customer, job ;
   WHERE custid=jobcustid ;

I am querying a microsoft access database table through an ODBC connection
using SQLEXEC, the numeric values in the access table are small decimals
defined as doubles. The values returned to my cursor are all rounded to 2
decimal places. I need these to be accurate to 9 decimal ...

I may be in the wrong group, if so, sorry....
Is is possible to copy a text file (fixed width) directly to a SQL table.  
I know I can use the APPEND FROM to get a text file to a dbf table, what
about to SQL.

Im having several Select statements to Get Counts of records for certain
conditions from several large tables.
Im using SQL server as the BE and VFP DLL as the middle tier.
I have two options to retrive the data.

Hi friends
I've textbox where i want user to enter numbers between 1 to 6.
I know i can write some validation in valid event.
i am wondering if there is property (like Inputmask) where i can set

Suppose in the student table, there are 6 different classes.
Now I do the following query (mtest is the mark of test):
select name, mtest from student ;
where mtest = (select max(mtest) from student group by class)

Hi Friends
I've following fields in a table.in some records all fields will be same
except transdate field (which contains date when this particular record is
created)