Hello,

We use DatabaseImport to import data from file into databse table ( sybase 12)
When we login as 'sa' it works fine, but when we use user id we were recieving error %'Please insure that you have a primary key on that table ...'%.

We do have a primary key and we granted permissions to this user.

Thanks,
Gennadiy

The user should be granted permissions to select from sysobjects, sysindexes and syscolumns.

: Hello,

: We use DatabaseImport to import data from file into databse table ( sybase
: 12)
: When we login as 'sa' it works fine, but when we use user id we were
: recieving error %'Please insure that you have a primary key on that table
: ...'%.

: We do have a primary key and we granted permissions to this user.

: Thanks,
: Gennadiy

The user granted to these objects and the message populated again.

exact message:

line 31: result set is not updateable, specified table must have a primary key"

line 31 in JAL sscript :

line 29: DatabaseSave( "c:\\temp\\file_name.CSV", "CSV", rows )
line 31: DatabaseImport("db_name..e_tbale_name", "c:\\temp\\file_name.csv", rows)

is any idea?

Thanks,
Gennadiy.

: The user should be granted permissions to select from sysobjects, sysindexes
: and syscolumns.

Is this table owned by dbo?

Have you tried db_name..e_tbale_name

DatabaseImport("db_name.dbo.e_tbale_name", ...)
or simply DatabaseImport("e_tbale_name", ...) ?

: The user granted to these objects and the message populated again.

: exact message: line 31: result set is not updateable, specified table must
: have a primary key"

: line 31 in JAL sscript : line 29: DatabaseSave(
: "c:\\temp\\file_name.CSV", "CSV", rows )
: line 31: DatabaseImport("db_name..e_tbale_name",
: "c:\\temp\\file_name.csv", rows)

: is any idea?

: Thanks,
: Gennadiy.

Yes,

this table owned by dbo
and I tried different way that you described below and it did not work.

and also I delete rows from the script:

ConcatEx "delete db_name..e_table_name where client in ('MM','C_MM') and bus_date = '", bus_date, "'", query
DatabaseExecute(query, rows)

This script works fine.

-Gennadiy

: Is this table owned by dbo?

: Have you tried db_name..e_tbale_name

: DatabaseImport("db_name.dbo.e_tbale_name", ...)
: or simply DatabaseImport("e_tbale_name", ...) ?

Before importing data into a table 24x7 retrieves that table definition and checks whether the current user has dbo role or owns the table. If yes, it checks if that table has a primary key or unique index.

If you cannot alias that user to dbo you can the following workaround:
Create a table in the user's schema.
Import into that table and then move data to the main dbo table.

If the database has "builb insert/select into" option enabled you don't event need a permanent table you can use the following technique

DatabaseExecute("SELECT * INTO #temp FROM dbo.e_table_name WHERE 0 = 1", rows)
DatabaseExecute("CREATE unique index i ON #temp(column names here)", rows)
DatabaseImport("#temp", "c:\\temp\\file_name.csv", rows)
DatabaseExecute("INSERT INTO dbo.e_table_name SELECT * FROM #temp", rows)
DatabaseExecute("DROP TABLE #temp", rows)

: Yes,

: this table owned by dbo
: and I tried different way that you described below and it did not work.

: and also I delete rows from the script: ConcatEx "delete
: db_name..e_table_name where client in ('MM','C_MM') and bus_date =
: '", bus_date, "'", query
: DatabaseExecute(query, rows)

: This script works fine.

: -Gennadiy