33
Views
1
Comments
[BulkInsert] How to deal with the DB field name with numeric prefix
Question
Forge component by João Pedro Abreu
22
Published on 02 Oct 2019

Hi all,

I find that it will have the issue if the field name starts with a numeric value.

Error will occur: 


Do anyone have the idea to deal with this case ? 

As the DB is from our client, we would not rename the field name .... 


Many Thanks,

Jayson

Rank: #3539

YourBuddy wrote:

Hi all,

I find that it will have the issue if the field name starts with a numeric value.

Error will occur: 


Do anyone have the idea to deal with this case ? 

As the DB is from our client, we would not rename the field name .... 


Many Thanks,

Jayson

By default, column names cannot begin with numeric characters (0-9). It must be an alphabetic character (A-Z). It is not a restriction of the Bulk Insert component, but of OutSystems.