Forum for DBF, dBASE, FoxPro, Clipper, xBASE http://forums.mysql.com/list.php?126 Tue, 24 Nov 2009 20:29:40 +0000 Phorum 5.2.1-alpha http://forums.mysql.com/read.php?126,277301,277301#msg-277301 http://forums.mysql.com/read.php?126,277301,277301#msg-277301
Any idea what would be causing this to happen?]]> gregory west DBF, dBASE, FoxPro, Clipper, xBASE Fri, 21 Aug 2009 16:03:57 +0000 http://forums.mysql.com/read.php?126,275984,275984#msg-275984 http://forums.mysql.com/read.php?126,275984,275984#msg-275984 I have a problem while sending email from a server the mail sending is not working because that server not supporting mai sending property but i have to send email in that web site.is it possible to send email using another server's server details in that site for sending email? pls give me an answer immedately..]]> Reshmi Babu DBF, dBASE, FoxPro, Clipper, xBASE Thu, 13 Aug 2009 16:13:14 +0000 http://forums.mysql.com/read.php?126,273605,273605#msg-273605 http://forums.mysql.com/read.php?126,273605,273605#msg-273605
I'm very new to mysql technology i need some information on how to see locks and blocks that are there in the database.....

Your help is highly appreciated....

Thanks,
Kumar]]> kumar raju DBF, dBASE, FoxPro, Clipper, xBASE Tue, 28 Jul 2009 16:00:21 +0000 http://forums.mysql.com/read.php?126,267887,267887#msg-267887 http://forums.mysql.com/read.php?126,267887,267887#msg-267887 The title is correct; can't find a .dbt file (note the t in .dbt).

I'm moving a Perl script from my windows xp machine to a linux server. When finished, a cronjob to run this program.

The program runs fine on the windows machine, but I'm having what seems to be an XBase bug on the linux machine.

I run a command on the command line to copy a bunch of FoxPro tables from one server (a foxpro production db) to another server/directory to be worked on. This works and copies all the table files (.dbf, .cdx, and .fpt). Note: not all the .fpt files get copied.

Then I run a Perl script which loops through an array of the table names, creates a tab-delimited txt file to be used as a datafile for a sql-loader command that uploads the data into Oracle tables. Piece of cake!

Problem:
I have about 50 tables. This all works fine on about 44 tables. On the others, I'm getting an XBase error about '... can't find file tablename.dbt' note the 't' in the extension.

Would anyone have an idea on what is causing this error? I'm baffled.

Code - main parts related...

use DBI;
use XBase;

#connection to foxpro
eval { $foxDbh = DBI->connect("dbi:XBase: // blah blah blah } # partial syntax

# Tables that wont run in command line: '
@CsoTableNames = ('cm', 'jb','mp', 'nt', 'rp', 'su');

foreach my $table (@CsoTableNames) {
$sql = "select * from $table";
eval{
$foxSth = $foxDbh->prepare($sql);
$foxSth->execute;
};
if($@){
$errorString = " Problem Selecting from FoxPro $table table.".$@;
print "Error on table $table : ".$errorString."\n";
SendEmail($errorString);
}
}

Error:
DBD::XBase::st execute failed: Table cm not found: Error opening file /home/path/to/tables/cm.dbt: No such file or directory

Error on table cm : Problem Selecting from FoxPro cm table.DBD::XBase::st execute failed: Table cm not found: Error opening file /home/path/to/tables/cm.dbt: No such file or directory

I've checked and tested the tables in the directory they are copied to. I can open them in FoxPro and the data is good. Again, this only happens on six of the fifty tables. Strange!

Any help or ideas would be GREATLY appreciated.]]> John Cowan DBF, dBASE, FoxPro, Clipper, xBASE Thu, 16 Jul 2009 05:57:48 +0000 http://forums.mysql.com/read.php?126,254878,254878#msg-254878 http://forums.mysql.com/read.php?126,254878,254878#msg-254878
i have a website contains 2 databases in the mysql. one database called 'information_schema' which was created by mysql, and another database called 'infodata' which created by me.

i use visual foxpro to write a program to access the database, the database show ok when i use SQLSTRINGCONNECT command to access the 'information_schema' database, but the database show error when i use SQLSTRINGCONNECT to access 'infodata' database, may i know what is wrong with database ? how to ratify this problem ? pls help me. thanks !!!]]> Darren Ang DBF, dBASE, FoxPro, Clipper, xBASE Thu, 07 May 2009 13:11:41 +0000 http://forums.mysql.com/read.php?126,249071,249071#msg-249071 http://forums.mysql.com/read.php?126,249071,249071#msg-249071 I have been using odbc connect to a remote mysql data base sucessfully.

Now I am on a different isp trying to connect.

my odbc system dsn can't connect and it looks like it is because the long isp name is added to my user name.

Help......

Lee]]> Lee Bjerke DBF, dBASE, FoxPro, Clipper, xBASE Sat, 21 Feb 2009 15:01:21 +0000 http://forums.mysql.com/read.php?126,247115,247115#msg-247115 http://forums.mysql.com/read.php?126,247115,247115#msg-247115
Give some links where can I get the information regarding configuration and programming tips

Thanks and regards
vijay]]> vijay kumar DBF, dBASE, FoxPro, Clipper, xBASE Wed, 18 Feb 2009 15:53:30 +0000 http://forums.mysql.com/read.php?126,239727,239727#msg-239727 http://forums.mysql.com/read.php?126,239727,239727#msg-239727
I'm trying to register an invoice that has:

a) a Header (table A - autogenerated ID)
b) a Body (table B - Foreign Key from Table A)

The point is that I'm trying to encapsulate that in a TRANSACTION with the following statements:

start transaction;
insert into A (ID) values (0); (ID=Integer autoincremental PK)
select @IDCAB=LAST_INSERT_ID();
insert into B (ID,FKCAB) values (0,@IDCAB); (ID=Integer autoincremental PK)
commit;


Assuming that the value of ID in A was 34, when I see the B's new register, the field FKCAB is NULL instead of 34.
Could you help me please?]]> Alberto Garcia Cano DBF, dBASE, FoxPro, Clipper, xBASE Tue, 23 Dec 2008 14:31:05 +0000 http://forums.mysql.com/read.php?126,238205,238205#msg-238205 http://forums.mysql.com/read.php?126,238205,238205#msg-238205
When saving text to a (longtext) field my text can contain TAB's (ASCII value 9). When editing a record I cannot insert further tabs. They are ignored when saving the changed content.

How to save TAB's?

Regards, Gerrit]]> gerrit broekhuis DBF, dBASE, FoxPro, Clipper, xBASE Fri, 12 Dec 2008 09:16:22 +0000 http://forums.mysql.com/read.php?126,237127,237127#msg-237127 http://forums.mysql.com/read.php?126,237127,237127#msg-237127 http://www.hostplanes.com]]> franklin fdsfdsf DBF, dBASE, FoxPro, Clipper, xBASE Thu, 04 Dec 2008 17:55:24 +0000 http://forums.mysql.com/read.php?126,228833,228833#msg-228833 http://forums.mysql.com/read.php?126,228833,228833#msg-228833
The VFP9 code to create a remote parameterized view (this is not a MySQL view) in a local database container file (DBC) seems to take a long time to complete, as if the code to create the parameterized view is actually causing a SELECT to be performed on the MySQL backend database. Example VFP Code:

CREATE SQL VIEW "V_MV_INDEX" REMOTE CONNECT "mysql_connection" ;
AS SELECT mv_index, veh_license, veh_state FROM mvehicle_index ;
WHERE veh_license = ?pcvlicense

When connecting to MS-SQL Server via ODBC this code works as expected/documented, simply creating the view definition (sort of a locally stored persistent SQL Statement) with a "?" placeholder for a variable that is defined at runtime, without launching any kind of search or select in the backend database. However, using the MySQL ODBC 5.1 Connector (also tried the 3.51 Connector) the creation of these VFP remote views takes a long time and the amount of time it takes seems to be proportional to the amount of data in the backend table.

More Details: Once created these views work as they should; no problem. Likewise my SQL passthru (SPT) code works very fast.

Does this behavior sound familliar to anyone? Does anyone have any suggestions?

Alec]]> Alec Gagne DBF, dBASE, FoxPro, Clipper, xBASE Mon, 02 Feb 2009 12:27:39 +0000 http://forums.mysql.com/read.php?126,228604,228604#msg-228604 http://forums.mysql.com/read.php?126,228604,228604#msg-228604 thank you i advance]]> mia jade DBF, dBASE, FoxPro, Clipper, xBASE Thu, 02 Oct 2008 07:02:10 +0000 http://forums.mysql.com/read.php?126,228583,228583#msg-228583 http://forums.mysql.com/read.php?126,228583,228583#msg-228583
Thanks in advanced.

Jerry]]> Jerry Yang DBF, dBASE, FoxPro, Clipper, xBASE Thu, 02 Oct 2008 03:08:46 +0000 http://forums.mysql.com/read.php?126,228158,228158#msg-228158 http://forums.mysql.com/read.php?126,228158,228158#msg-228158
At my client with MySQL, I get a successful connection via ODBC to the VOX database, but every attempt to access a table eg "select * from Vox_Projects" I get an error "..Table vox.vox_projects not found.

I'm on a machine that accesses and updates this table in the VOX database thru Access.

I don't have the MySQL command program on the computer I'm on at the client's office. The programmer who set it up is in NY and says it was years ago, so is not a big help.

Could this be a privileges issue? Can they hide the tables from a different program? Is there a SQL command I could execute in my compiled program to test for it?

Or do I need to get access to their computer with the MySQL command program to see and change the privileges?

Or can I download the free MySql onto the machine I use there and run the MySql command line and change from there?]]> Kris Dahlin DBF, dBASE, FoxPro, Clipper, xBASE Mon, 29 Sep 2008 04:38:15 +0000 http://forums.mysql.com/read.php?126,215048,215048#msg-215048 http://forums.mysql.com/read.php?126,215048,215048#msg-215048
mysql -> csv -> dbf(using Append from csv type delim) -> program checking dbf -> load to main dbase program

Whenever, I try this process ,the checking program reports an error. Also, when I open the dbf file(generated from mysql) with notepad , I can see the file looks very different from the other dbf files that work fine. The collation I use in mysql is utf8_general_ci. Is there something I could do to resolve this issue.]]> S D DBF, dBASE, FoxPro, Clipper, xBASE Sat, 21 Jun 2008 14:42:21 +0000 http://forums.mysql.com/read.php?126,212113,212113#msg-212113 http://forums.mysql.com/read.php?126,212113,212113#msg-212113
In VISTA OS. I am using the MS ODBC dBase Driver for using the dBase Database files.

When i try to create UNIQUE INDEX one one of dBase Table using the SQL Query through the exception.

SQL Query: CREATE UNIQUE INDEX [CURRENCY] ON CURRENCY (CURRNAME)

When i execuet this through the exception with State:37000 and Native error 3552.

This problem happens on only Vista OS . I am using VS 2003 with MFC CDatabase class.

NOTE: In the above statement if i rename table name CURRENCY to any name then works fine. My requiremement is i should not chnage table name CURRENCY.

I need your help badly waiting for your suggestion reply.

-Vivek]]> Vivek H DBF, dBASE, FoxPro, Clipper, xBASE Mon, 02 Jun 2008 18:08:44 +0000 http://forums.mysql.com/read.php?126,211255,211255#msg-211255 http://forums.mysql.com/read.php?126,211255,211255#msg-211255 HOW TO PERFORM SQL QUERY NOTIFICATION IN MYSQL 5.0/5.1/6.0.Plese Suggest.]]> Mohan Kalyan DBF, dBASE, FoxPro, Clipper, xBASE Sun, 01 Mar 2009 13:54:54 +0000 http://forums.mysql.com/read.php?126,204559,204559#msg-204559 http://forums.mysql.com/read.php?126,204559,204559#msg-204559 What I want to know is what I'm supposed to do to get the "error" message for instance when I want to do an INSERT and the key of an index is duplicated? Is there a MySQL function that returns that thing?
Thank you]]> Alberto Garcia Cano DBF, dBASE, FoxPro, Clipper, xBASE Tue, 22 Apr 2008 05:47:16 +0000 http://forums.mysql.com/read.php?126,203828,203828#msg-203828 http://forums.mysql.com/read.php?126,203828,203828#msg-203828 I am trying to insert some data into mysql table as follow:
Public aErrorArray(7)
A1="ABC"
A2="100"
A3="DESC"
A4=6
aErrorArray = 0
= SQLSetprop(Nc, 'Transactions', 2)
= SQLExec(Nc, "INSERT INTO MYTABLE (X1,X2,X3,X4);
VALUES ('&A1','&A2','&A3','&A4')")
= Aerror(aErrorArray)

If aErrorArray(1) = 0
Sqlcommit(Nc)
ENDIF

but it gives me the following error :

Connectivity error: [MySQL][ODBC 3.51 Driver][mysqld-5.1.23-rc-community]Data truncated for column 'X4' at row 1"
"[MySQL][ODBC 3.51 Driver][mysqld-5.1.23-rc-community]Data truncated for column 'X4' at row 1"

If I put the 6 direct in place of '&A4' like this '6' it works fine and it saves the record correct in the table.
the field type in mysql table is float but I have tried various types it did not work.
Any solution please, thanks in advance.]]> Tarik ALKATHIRI DBF, dBASE, FoxPro, Clipper, xBASE Tue, 22 Apr 2008 05:51:42 +0000 http://forums.mysql.com/read.php?126,203680,203680#msg-203680 http://forums.mysql.com/read.php?126,203680,203680#msg-203680
I plan to use Java & Mysql (on win xp).

What softwares do I need to download from the Mysql site ?

Any suggestions would be greatly appreciated.

Thanks.

Ravi Banthia]]> Ravindra Banthia DBF, dBASE, FoxPro, Clipper, xBASE Fri, 04 Apr 2008 23:33:24 +0000 http://forums.mysql.com/read.php?126,201982,201982#msg-201982 http://forums.mysql.com/read.php?126,201982,201982#msg-201982
Thanks]]> Carlos Torres Suarez DBF, dBASE, FoxPro, Clipper, xBASE Tue, 22 Apr 2008 05:53:31 +0000 http://forums.mysql.com/read.php?126,201981,201981#msg-201981 http://forums.mysql.com/read.php?126,201981,201981#msg-201981
Thanks]]> Carlos Torres Suarez DBF, dBASE, FoxPro, Clipper, xBASE Thu, 08 May 2008 22:56:09 +0000 http://forums.mysql.com/read.php?126,201820,201820#msg-201820 http://forums.mysql.com/read.php?126,201820,201820#msg-201820
i want to access an ODBC database (Visual FoxPro) with MySQL.
Is there any solution?

Example: Query a visual FoxPro DB with MYSQL Query Browser through ODBC

Wolfgang]]> W M DBF, dBASE, FoxPro, Clipper, xBASE Tue, 20 May 2008 04:54:06 +0000 http://forums.mysql.com/read.php?126,196325,196325#msg-196325 http://forums.mysql.com/read.php?126,196325,196325#msg-196325
every body is there is a way how to import data from ACT files MySQL please give me some response.]]> srinivas pmm DBF, dBASE, FoxPro, Clipper, xBASE Thu, 14 Feb 2008 11:39:16 +0000 http://forums.mysql.com/read.php?126,196116,196116#msg-196116 http://forums.mysql.com/read.php?126,196116,196116#msg-196116
every body i have a requirement importing ACT files into MySQL database.

i came to know tht ACT files are foxpro data base files. please tell me how to

import ACT files into Mysql]]> srinivas pmm DBF, dBASE, FoxPro, Clipper, xBASE Wed, 13 Feb 2008 06:05:24 +0000 http://forums.mysql.com/read.php?126,193268,193268#msg-193268 http://forums.mysql.com/read.php?126,193268,193268#msg-193268 I am trying to link our current inventory software (OakSt) which stores its information in dbfs to our MySQL. This will allow our customers to see certain information online. I can do this with DBF-to-MySQL 2.1 manually at the end of the day but I am looking for a solution that would update automatically as the tables are changed in the office. Does anyone know software or method that would do this?]]> Mick Donahue DBF, dBASE, FoxPro, Clipper, xBASE Fri, 28 Nov 2008 14:35:44 +0000 http://forums.mysql.com/read.php?126,193254,193254#msg-193254 http://forums.mysql.com/read.php?126,193254,193254#msg-193254
I have been doing quite a bit with VFP9 and MySQL and am now working on adding some functionality to my VFP framework. I use ODBC and SQL PassThru to transmit data to/fro the mysql.

My question deals with Update conflicts and transactions. I was wondering if anyone here had any ideas how to deal with changes made to a record by another user while the current user is in an edit session. As a corrolary to that, I was wondering if there might be a locking mechanism in MySQL that would allow me to, in effect, pessimistically lock an object (meaning, noone could edit it while the current user does).

As a second issue, how does one implement transactions in MySQL using ODBC? I am a newbie on that issue as well.

Thank you in advance for any pointers you can send my way.

Menachen]]> Menachem Bazian DBF, dBASE, FoxPro, Clipper, xBASE Thu, 24 Jan 2008 16:30:12 +0000 http://forums.mysql.com/read.php?126,177361,177361#msg-177361 http://forums.mysql.com/read.php?126,177361,177361#msg-177361
I am newbie and I have a problem our lead programmer quit, yes it quit, so I was left with his project, and my background is very diferent to his, so now I am stuck with this project, the thing is that I need to convert daily 25 foxpro databases into MySql and to be honest I have no clue on how to do a Perl program can someone in here can enlight me with an exaple
TIA]]> Armando Gomez DBF, dBASE, FoxPro, Clipper, xBASE Wed, 27 May 2009 04:52:57 +0000 http://forums.mysql.com/read.php?126,177147,177147#msg-177147 http://forums.mysql.com/read.php?126,177147,177147#msg-177147 Tan SooKiang DBF, dBASE, FoxPro, Clipper, xBASE Wed, 31 Oct 2007 12:12:39 +0000 http://forums.mysql.com/read.php?126,175804,175804#msg-175804 http://forums.mysql.com/read.php?126,175804,175804#msg-175804
Thanks,
Gerry]]> Gerry Reno DBF, dBASE, FoxPro, Clipper, xBASE Tue, 02 Oct 2007 20:29:15 +0000