DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Ajax DataGrid  
DwZone Forum Index -> Ajax DataGrid
.
Moderators: AdministratorsModerators 
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.
New Topic Search for
 View     Per page     Messages Since 
Messages 1 to 10 of 96 (Total: 94) First |  Prev |  Next |  Last  
 Subject Author Date  
   Dreamweaver 2021  
View this persons public profile  IvanSinigaglia   15:18 13 Jun 2021  
   Dreamweaver 2021  
View this persons public profile  IvanSinigaglia   15:15 13 Jun 2021  
    Ajax Data Grid Version 1.4.33 - MasterAndDetail Data Grid - UniqueColumnKey PULL DOWN will only show: None  
View this persons public profile  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
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: Ajax Data Grid Version 1.4.33 - MasterAndDetail Data Grid - UniqueColumnKey PULL DOWN will only show: None  
View this persons public profile  Gianluigi   5:04 28 May 2020  
   Re: Ajax Data Grid Version 1.4.33 - MasterAndDetail Data Grid - UniqueColumnKey PULL DOWN will only show: None  
View this persons public profile  heise   5:15 28 May 2020  
   Re: Ajax Data Grid Version 1.4.33 - MasterAndDetail Data Grid - UniqueColumnKey PULL DOWN will only show: None  
View this persons public profile  Gianluigi   5:29 28 May 2020  
   Re: Ajax Data Grid Version 1.4.33 - MasterAndDetail Data Grid - UniqueColumnKey PULL DOWN will only show: None  
View this persons public profile  heise   6:55 28 May 2020  
   Re: Ajax Data Grid Version 1.4.33 - MasterAndDetail Data Grid - UniqueColumnKey PULL DOWN will only show: None  
View this persons public profile  heise   7:02 28 May 2020  
   Re: Ajax Data Grid Version 1.4.33 - MasterAndDetail Data Grid - UniqueColumnKey PULL DOWN will only show: None  
View this persons public profile  heise   8:15 28 May 2020  
   Sorting "descending" question  
View this persons public profile  Adrian Cordea   11:01 22 May 2020  
Last Visit: Sunday 24 Oct, 2021 3:46 pm First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: