Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Down

Help! I do Select * From T1 -> refresh -> error (ADODataSet) Find similar branches


nic406   (2001-11-28 04:21) [0]

1. In ADODataSet (CommandText) I set Select * from T1. On the form
TDataSource, ADODataSet and GRID are related. -> Dset.Open -> information in Gride (Ok!). deleting the record is normal. I do Dset.Refresh -> osh. "Insufficient key column information for refreshing" -> what's the matter?
2. Help make the Stored Procedure (SQL2000) for Select, running on the Server and allowing you to - search, sort (2,3 column) and how to start from Delphi5 (ADO) - which type of cursor is better to use and how to bind parameters. Selection by 1 record is not interesting -> Grid filling is required
Thank you in advance for your help. New to SQLServer.
My E: mail kivc406@mail.ru



Flagman   (2001-11-29 07:21) [1]

Or maybe try not refresh, but requery?



Polevi   (2001-11-29 08:12) [2]

1. Primary key is needed in the table



amamed_3071   (2001-11-29 08:59) [3]

Dset.Refresh REPLACE FOR REQUERY TO FROM adoquery1.requery



nic406   (2001-12-04 07:06) [4]

Thanks a lot!



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Top









Memory: 0.56 MB
Time: 0.022 c
14-22369
Victor Tsay
2001-11-08 09:11
2002.01.08
How in the Delphi editor to shift blocks of text?


1-22190
T2
2001-12-14 03:22
2002.01.08
KillSelf


3-21920
Alex2
2001-12-04 15:14
2002.01.08
Error at completion


1-22180
Nathan
2001-12-21 11:07
2002.01.08
Problem!


1-22093
Bristol
2001-12-19 11:59
2002.01.08
sending letters using Delphi 5





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic indonesian Irish italian Japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Español swahili Swedish thai turkish Ukrainian urdu vietnamese welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish