× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ashwini.chavan reported 2013-09-25T04:57:03Z  · SachinPrakash last modified 2014-06-09T23:24:55Z

Table data Editor does not work for searching date time string


Dev
Kin-Hong Wong
kin-hong
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - Table Data Editor
Version Future - .9
Aqua Data Studio 14.0.0-rc-27 Database-MS SQL Server 7.0
 
Please go through following steps:
 
A)Create Table:
 
1)Connect to "MS SQL Server 7.0"->Go to Databases->Right click on "User Tables" object folder->Select "Create Table" option->New create table dialog is opened. 
 
2)I have created Table as follows:
  "CREATE TABLE [Ashwini_schema].[third_data_type]
  ( [c1] nchar(25) NULL,
    [c2] ntext NULL,
    [c3] numeric(15,5) NULL,
    [c4] nvarchar(25) NULL,
    [c5] real NULL,
    [c6] smalldatetime NULL,
    [c7] smallint NULL,
    [c8] smallmoney NULL,
    [c9] uniqueidentifier NULL) 
ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] WITH (DATA_COMPRESSION = NONE)"
 
Table is created.In table "c6" column having "smalldatetime" datatype.
 
3)I have inserted some records in table.
 
4)Right click on table("third_data_type")->Select "Edit Table Data(Top 1000)"->Edit table data window is opened.
 
5)In Table Data Tab go to search icon & click on it->Drop down list is pop up->Checked on "c6" column->Enter Date & time string in text box->No any result is display for entered string.
 
 
 
 
 
 
 
3 attachments

Issue #10190

Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017