Ajax Data Grid Version 1.4.33
add a MasterAndDetail Data Grid
in the Wizard Register Field1:
The Connection to SQL Server is working
Table Name: dbo.T_BVRfileupload was found; all other SQL Server Tables are also shown, Connection will work !!!
Recordset: rsBVRFileupload is found in the Website
but in the next field: "Unique column key" there is Nothing going, it will Show onle: None and above is the text: Must be a numeric field
Here is the table structure:
CREATE TABLE [dbo].[T_BVRfileupload](
[IDNR] [int] IDENTITY(1,1) NOT NULL,
[IP_DATVO] [datetime] NULL CONSTRAINT [DF_T_BVRfileupload_IP_DATVO] DEFAULT (getdate()),
[IP_TIMES] [timestamp] NOT NULL,
[IP_NGNO1] [nvarchar](50) NULL,
[IP_FILEN] [nvarchar](250) NULL,
[integerrwert] [int] NULL,
[decimalwert] [decimal](18, 0) NULL
) ON [PRIMARY]
i have inserted some "numeric fields" for this test.
here is the recordset in ASP VbScript:
Set rsBVRfileupload_cmd = Server.CreateObject ("ADODB.Command")
rsBVRfileupload_cmd.ActiveConnection = MM_DB_STRING
rsBVRfileupload_cmd.CommandText = "SELECT * FROM dbo.T_BVRfileupload WHERE IP_ANSPA = ? "
rsBVRfileupload_cmd.Prepared = true
rsBVRfileupload_cmd.Parameters.Append rsBVRfileupload_cmd.CreateParameter("param1", 200, 1, 50, rsBVRfileupload__MMColParam) ' adVarChar
Set rsBVRfileupload = rsBVRfileupload_cmd.Execute
rsBVRfileupload_numRows = 0
Where is the Problem with the "Unique column key" ???