Prev: Debugging with Visual Studio heap problems
Next: 'MathWorks::System::_utException' Error
From: Alessandro C. on 26 Jan 2007 03:30
After many many trials, I discovered that the 'fastinsert' function
of the Database Toolbox is not able to insert any data (date, number,
string, ...) in a database (MS Access) if the field has the name
'Date'. No mention of this in the user's guide.

I presume that such a name may be a reserved word for the
'fastinsert' function code. My question is: are there some other word
that cannot be used? Just in case...

Txs
From: Lars Gregersen on 26 Jan 2007 04:52
Alessandro C. wrote:
>
>
> After many many trials, I discovered that the 'fastinsert' function
> of the Database Toolbox is not able to insert any data (date,
> number,
> string, ...) in a database (MS Access) if the field has the name
> 'Date'. No mention of this in the user's guide.
>
> I presume that such a name may be a reserved word for the
> 'fastinsert' function code. My question is: are there some other
> word
> that cannot be used? Just in case...

Any keyword defined by the SQL language should be avoided. Also you
shouldn't ever use table names with spaces.

Lars
 | 
Pages: 1
Prev: Debugging with Visual Studio heap problems
Next: 'MathWorks::System::_utException' Error