MyDump problem

[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

[Antaeus]

Please supply us with script to create table.

[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

[Antaeus]

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

[jepdk]

When do you expect to release the next version?

Jan

[Antaeus]

The next build of MyDAC will be available during next two weeks.

[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?

[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.

[jepdk]

When do you expect the fix to be applyied?

Jan

[Antaeus]

We plan to release the new build of MyDAC in about a couple of weeks.

[jepdk]

Just upgraded to 4.40.0.21

Problem NOT solved!

Jan

[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.

[jepdk]

To reproduce the error look at me post from oct. 23.

It's all there

Jan

[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.