Forums :: Ajax DataGrid :: DwZone Forum

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Ajax DataGrid

DwZone Forum Index -> Ajax DataGrid
.
Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 1 to 10 of 96 (Total: 94)

First | Prev | Next | Last

Subject

Author

Date

Dreamweaver 2021

IvanSinigaglia

15:18 13 Jun 2021

Dreamweaver 2021

IvanSinigaglia

15:15 13 Jun 2021

Ajax Data Grid Version 1.4.33 - MasterAndDetail Data Grid - UniqueColumnKey PULL DOWN will only show: None

heise

4:45 28 May 2020

Dreamweaver 6CS
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:

Dim rsBVRfileupload
Dim rsBVRfileupload_cmd
Dim rsBVRfileupload_numRows

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

Regards
Andreas

Andreas