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.55 MB
Time: 0.025 c
1-22190
T2
2001-12-14 03:22
2002.01.08
KillSelf


3-21935
hair
2001-12-03 15:12
2002.01.08
Data Storage


6-22300
evgen_2001
2001-10-04 12:25
2002.01.08
Sending messages


3-21969
Kozhanov
2001-11-30 18:31
2002.01.08
OBDC driver options


6-22274
Polevi
2001-10-08 10:42
2002.01.08
And why do we need sockets ???





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 Spanish 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