Hi, I have a situation like this: I have a web-page where several "textboxes" and have an Excel file. I have no direct access to web-page, that is, I can only open it in web-browser - https:// I need to copy data from Excell cell into textbox, and push an ENTER button. Of course, the web-page is open at the moment. I know how to copy data from Excel into html, but have no experience how to copy into textbox in an open IE. and how to push link/button in IE. could anybody help ???

Respectfully, Exceter.

Hi, In ASP.NET (c#) I need to refresh another page after inserting some data in one page. These are not parent/child pages. I have to pages, say, one main, the other depends on it. In second page there is an image control, which must change depending on the data of the first page. how to make the second page refresh on button event(press)? Respectfully, Exceter.

Hi, here I was trying to open two Recordsets with one Connection. but I got _com_error message that it is not allowed to open two Recordsets with one Connection. Then I tried two Connections, but something is wrong, could anyone explain me how to have multiple Recordsets, or Connections in one application? And, Why I fail to move to previous Record in VIEW? Isn't it possible to move to previous Record which reads from the VIEW? Respecfully, exceter

But 1/10 errors of your code was because of the compiler. but as I said, my program was working, and I got that error. and later, it started working again. I do not think that was my fault. thatnx.

But 1/10 errors of your code was because of the compiler. but as I said, my program was working, and I got that error. and later, it started working again. I do not think that was my fault. thanx.

Yes, it worked fine for me too, at least for last 2 months. but yesterday it stopped working. I checked that in DEBUG. :eek:Unbelievable, now it is working, I changed nothing in the code, NOTHING, it works:omg: What is going on!!!

Hi, how to do it properly? I tried following: TCHAR tch[20]; CString str; ..... str = tch; but Have an error, do not what kind of, know that because of the assignment. Thanx.

I found what the mistake was myself. thanx anyway. I hope you will answer my future questions. Best Regards exceter.

Hi, plz, help me with the following, (the code is attached) Trying to insert, I have the following message: (1 row(s) affected) Server: Msg 8152, Level 16, State 9, Procedure Trig_PUD, Line 8 String or binary data would be truncated. The statement has been terminated. the Code is: CREATE TABLE PersonalFile ( IDnum int identity(1,1) not null, PersonalFile varchar(10) not null CONSTRAINT PK_PersonalFile PRIMARY KEY ) CREATE TABLE University ( PersonalFile varchar(10) not null CONSTRAINT PK_UniversityPF PRIMARY KEY REFERENCES PersonFile, University varchar(50) not null ) CREATE TABLE Department ( PersonalFile varchar(10) not null CONSTRAINT PK_DepartmentPF PRIMARY KEY REFERENCES PersonFile, Department varchar(50) not null ) CREATE VIEW PUD AS SELECT P.PersonalFile, U.University, D.Department FROM PersonalFile P, University U, Department D WHERE (P.PersonalFile = U.PersonalFile) and (P.PersonalFile = D.PersonalFile) CREATE TRIGGER Trig_PUD ON PUD INSTEAD OF INSERT AS BEGIN INSERT INTO PersonalFile(PersonalFile) SELECT PersonalFile FROM inserted INSERT INTO University(PersonalFile,University) SELECT University, PersonalFile FROM inserted INSERT INTO Department(PersonalFile, Department) SELECT PersonalFile, Department FROM inserted END insert into PUD(PersonalFile, University, Department) values('123445', 'Univerdity1', 'Department1') Best Regards, exceter.

Greate, it works. thanx. but, how to make it to work with Getbuffer()? well, in this program I know the estimated sizes of the buffer, but if it exceeds the buffer size I've shoen there?

Yes, I gorgot to Release the buffer, thanks. but, now I have an error in ReleaseBuffer()!!! the error message is: file:c:/...vc7//atlmfc/include/atlsimpstr.h line: 718 Expression: nLength <= GetData()->nAllocLength

reg.QueryDWORDValue("NumOfComputers", num); reg.QueryStringValue(val, (Cname.GetBuffer(len)), &Cname_sz); These functions exists in VC7, they do not make the error. The error is I think with the CButton array, because if I make a sinlge button (not array) the program works, that is, the dialog and the button are created.

private: CButton Comps[5]; CRegKey reg; ....... (reg.Open(HKEY_LOCAL_MACHINE, "Software\\ShutDown") == ERROR_SUCCESS ) { reg.QueryDWORDValue("NumOfComputers", num); POINT pt1, pt2; pt1.x = 20; pt1.y = 20; pt2.x = 120; pt2.y = 50; ULONG Cname_sz; char buf[20]; CString cn, Cname; for (int i=0; i< maxComps; i++) { CRect tmpRect(pt1, pt2); LPCTSTR val = (LPCTSTR) itoa(i, buf, 10); int len = Cname.GetLength(); reg.QueryStringValue(val, (Cname.GetBuffer(len)), &Cname_sz); Comps[i].Create(_T(Cname), WS_CHILD|WS_VISIBLE|BS_AUTOCHECKBOX, tmpRect, this, 1210+i); pt1.y += 30; pt2.y += 30; Cname.Empty(); } .........

private: CButton Comps[5]; CRegKey reg; ....... (reg.Open(HKEY_LOCAL_MACHINE, "Software\\ShutDown") == ERROR_SUCCESS ) { reg.QueryDWORDValue("NumOfComputers", num); POINT pt1, pt2; pt1.x = 20; pt1.y = 20; pt2.x = 120; pt2.y = 50; ULONG Cname_sz; char buf[20]; CString cn, Cname; for (int i=0; i< maxComps; i++) { CRect tmpRect(pt1, pt2); LPCTSTR val = (LPCTSTR) itoa(i, buf, 10); int len = Cname.GetLength(); reg.QueryStringValue(val, (Cname.GetBuffer(len)), &Cname_sz); Comps[i].Create(_T(Cname), WS_CHILD|WS_VISIBLE|BS_AUTOCHECKBOX, tmpRect, this, 1210+i); pt1.y += 30; pt2.y += 30; Cname.Empty(); } ......... Best Regards, exceter

Sir, Sorry for a such question, but I am new in SQL. Could you show how that trigger is written? Respectfully exceter.

Hi, Simple question : I have a table and one column is ID (int identity(1,1) not null). Say I have 5 rows: [u]ID Name Color [/u] 1 Bob White 2 Jane Black 3 Lucy Red 4 Gang Brown 5 Dub Yellow If I delete the row 3, the remaining ID's are 1, ,2, 4, 5. Is it possible to make the remaining after the deletion row 3 1, 2, 3, 4? that is the above ID's to decrement. __________________ Best regards, Exceter.

How can I disallow the OK button in tabbed dialog box?

is it possible to get the data of table except for one column? that is, if I have a table with column names ID, Name, Address, ... How can I get the data of all columns except for ID column? and, how to get the column names(not the data) ? for table names I found the following: Select * from sysobjects where [type] in ('U')

What you mean "show the table" I assume you wanna show the data of the table? You need EditBox, StaticBox, (may be ComboBox) for the data to be shown on the dialog box.

well, for Cancel button I need nothing, what I need is when the OK button pressed, to check if the Edit Box is Empty, if it is empty, not closing the dialog (Tabbed) Box, go set the Focus to that Edit Box. I managed to check the Edit, but the Dialog (tabbed) Box closes. I do not press te Cancel Button.