This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi There I use a datagrid to retrive data via a storeprocedure, The storedprocedure just retrive most data from one table (the table is a simple one with first field named Id, I didn't set it as key filed but it's unique anyway) I got a problem that only Id field is show up but all other column is empty. I wonder if it is a bug? By the way is it the Id field returned must be an int filed? I change Id field from vchar to int but still got the same problem. StoreProcedure: SELECT Id, ProgressStatus As StatusI, inctypeid, creationdate, Estrestdate, plannedflag, ozname, primaryname, secondaryname, componentdescription, numoffsupply, numsensitive, maxnumoffsupply, inccomment, loginname, PrimaryAlias, SecondaryAlias, Deaddevicealias, report_ref from TestTable Table [dbo].[TestTable]( [Id] varchar NOT NULL, [ProgressStatus] varchar NULL, [inctypeid] varchar NOT NULL, [creationdate] [datetime] NOT NULL, [Estrestdate] [datetime] NULL, [plannedflag] varchar NULL, [ozname] varchar NOT NULL, [primaryname] varchar NULL, [secondaryname] varchar NULL, [componentdescription] varchar NULL, [numoffsupply] nvarchar NULL, [numonsupply] nvarchar NULL, [numsensitive] nvarchar NULL, [maxnumoffsupply] nvarchar NULL, [inccomment] varchar NULL, [loginname] varchar NULL, [PrimaryAlias] varchar NULL, [SecondaryAlias] varchar NULL, [Deaddevicealias] varchar NULL, [reportref] varchar NOT NULL, Could you have a look and let me know what the problem??? Thank you very much for your help! Winnie |
|
|
|
|
Hi There Sorry my post above for table design is not the right one. I think I found the problem. The storedProcedure retrived data from the table which have most column naming have under scores like creation_date and lightspeed directly changed the name to creationdate in model entity design time. When the stored procedure is called, this field cannot be found in the table of real database and return an empty column I guess. But it only happened for a stored procedure instead of a table, it Seems lightspeed have some way to work around it for tables. I don't think it's a bug, but just something time make things little confused. Thanks any way! Winnie |
|
|
|
