I have a program which retrieves record from the SQL table. This is the program:
STORE SQLCONNECT('dbcsqllibrary', 'sa') TO lnConnHandle
IF lnConnHandle <= 0
MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
ELSE
MESSAGEBOX('Connection made', 48, 'SQL Connect Message')...
My group in the development team is evaluating ways by which we can retrieve records the fastest way. Our database is MS SQL and our programming language is VB 6.0. My question is which is faster in terms of record retrieval, SQL's view or programmatically bound a control's recordsource to a...
I have already finished my system with databases and tables defined in VFP meaning the *.dbf and *.dbc files. I was told by my superior to migrate it to MS SQL. I don't have experience yet in this implementation. All I know is to connect through remote views. But how can I reference to these...
How can I connect to MS SQL using DAO if it does not have ODBC? I already have finished coding the app using DAO on MS Access tables. But my boss told me to migrate my databases to MS SQL. How can I do that with DAO?
I am currently migrating MS access databases to MS SQL. I have a field with a decimal data type in MS Access with a field length 16 and 2 decimal place values (values after the decimal point). How is this converted in MS SQL if Decimal data type has a maximum field length of only 9? I...
Sorry guys, but I need all the help I can get. I already posted this problem under the Microsoft VFP forum but I don't have response yet. Maybe guys here in this forum can help me. How can i attach my application menu (namely Transaction and Administration) be a part of the default menu of IE...
How can i attach my application menu (namely Transaction and Administration) be a part of the default menu of IE (e.g. File, Edit, View, Favorites, Tools, Help). I already made an activedoc class which calls my main.prg. My main.prg calls the menus created by the wizard. When I loaded my app...
I'm already finished with my application, having compiled it into an executable file. Now, my boss asked me if I could implement my application as browser-based so that user's can access my app through the internet browser. I read about Active Document application in the Visual Studio help file...
I've already finished my system and i'd like it to have it browser-based or internet-based so I can just have it posted on our intranet site. The problem is I haven't done this before. Anyone who could help me start this project? Thanks a lot. This forum really helps me.
Vlad,
SELE Table -> select the table
BROW -> check if the record was added. it was indeed added
USE -> to close the table to force the view to refresh
USE Table IN 0 -> open it again
SELE View -> select the view
BROW -> to check if the...
Ramani,
I already did this when I was waiting for your response but it still didn't work. At the GotFocusEvent of the combobox, I put
This.Requery()
then, run the program but it didn't work. I noticed that when I quit the program and execute again then check the combobox list...
Ramani,
Can you elaborate further when you said i will requery the view in the GotFocusEvent? At GotFocusEvent, I just put -> Requery("requestview") [requestview being the local view] but still it did not work. Is this what you're talking about or another thing? I appreciate very...
Currently I am working with a library system. I've got a problem with regards to a view which is bound to a combobox. Let me cite 2 transactions which in effect have to 2 tables: Requesting of Titles to be Bought Transaction --> "tblRequest.dbf" and Title Quotation Transaction ->...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.