Page 1 of 1
MyDump problem
Posted: Mon 23 Oct 2006 13:56
by jepdk
Using MSAC ver. 4.40 in Delphi 2006 I have a problem with som fields in my database.
I have a fieldname ending with a period, ex. "FIELD1."
I get an error trying to backup data (Field "FIELD." not found).
Is there any way to get around this?
Component MyTable has an option to fix this, but I don't see this option in Mydump component.
Jan
Posted: Mon 23 Oct 2006 14:48
by Antaeus
Please supply us with script to create table.
Example code for error in Mydump
Posted: Mon 23 Oct 2006 17:40
by jepdk
-- Below is what MyDump do. Note field "Regnr."
-- and here is data in the table:
insert into `test` values
('Example','none','http://www.webadr.dk',1,'Test.asc','N:\Bank\,'','',0,'C:\Program\FIKORT','S:\Arkiv');
-- -----------------------------------------------------------------------
-- MyDAC version: 4.40.0.19
-- MySQL server version: 5.0.20-nt
-- MySQL client version: 4.1.3 Direct
-- Script date 23-10-2006 19:26:33
-- ----------------------------------------------------------------------
-- Server: localhost
-- Database: test
--
-- Database test structure
--
USE mysql;
DROP DATABASE IF EXISTS test;
CREATE DATABASE test;
USE test;
--
-- Table structure for table demo
--
DROP TABLE IF EXISTS demo;
CREATE TABLE `demo` (
`Pengeinstitut` varchar(40) default '',
`On-Line Program` varchar(20) default '',
`DataPath` varchar(100) default '',
`Standard` tinyint(1) default NULL,
`OutputFilnavn` varchar(15) default '',
`OutputPath` varchar(100) default '',
`PI_Kode` varchar(5) default '',
`Regnr.` varchar(4) default '',
`KontoNr` int(11) default '0',
`FiDataPath` varchar(100) default '',
`FiArkivPath` varchar(100) default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=' Example';
--
-- Dumping data for table demo
--
LOCK TABLES demo WRITE;
INSERT INTO demo VALUES
-----------------------------------------------------------------------
At this point I get an exception saying "Field Regnr. not found"
Jan
Posted: Tue 24 Oct 2006 06:32
by Antaeus
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.
Thank you
Posted: Tue 24 Oct 2006 14:22
by jepdk
When do you expect to release the next version?
Jan
Posted: Wed 25 Oct 2006 06:37
by Antaeus
The next build of MyDAC will be available during next two weeks.
Next build?
Posted: Sun 12 Nov 2006 13:21
by jepdk
version 4.40.0.20 don't fix the problem about a period in a field name.
When do you expect the fix to be applyied?
Posted: Tue 14 Nov 2006 13:36
by Antaeus
You are right, the fix included into the last build does not solve this problem completely. We will include the fix to this problem into the next MyDAC build.
Next build?
Posted: Tue 21 Nov 2006 02:29
by jepdk
When do you expect the fix to be applyied?
Jan
Posted: Tue 21 Nov 2006 12:15
by Antaeus
We plan to release the new build of MyDAC in about a couple of weeks.
Still not fixed!
Posted: Mon 11 Dec 2006 10:17
by jepdk
Just upgraded to 4.40.0.21
Problem NOT solved!
Jan
Posted: Mon 11 Dec 2006 13:11
by Antaeus
We can not not reproduce the problem with the current version of MyDAC.
Please send us (evgeniyD*crlab*com) a complete small sample to demonstrate it.
Also send us your license information.
You have it
Posted: Wed 13 Dec 2006 13:02
by jepdk
To reproduce the error look at me post from oct. 23.
It's all there
Jan
Posted: Thu 14 Dec 2006 14:16
by Antaeus
We ask you for example to make sure that the problem you have encountered is fixed completely. Please make a small sample with a single button that does the following:
- connects to the server;
- creates a table and fills it with data if necessary;
- assigns parameters to MyDump and runs it.
Including your registration information is also required if you are registered user of MyDAC.