Search results for query: *

I have a program where I am extracting the table name via CursorGetProp("tables"). I am processing approx 20 tables and this function works great on all tables except one. I cannot understand why this is not working for one table!! I far as I can tell, there is nothing different about this table...

I have a stored procedure in which I reset the indentity field using the dbcc checkident ("TableName",reseed,0) command. Everything works as expected but I am having something strange happen with a few of my customer when they run the stored procedure. 99% are able to run the stored procedure...

I have a basic Yes No message box where I would like the user to be able to press escape when the message box appears as a 'No' answer. Is there a way to do this ? Kflasph

I have built a Common Table Expression that gives me the results I need and I would like to loop through the results to run other selects with each record. Is it possible to create a cursor with the results of a CTE? I can run the CTE then select the information from the table in a simple...

I have a program that I created a PopupMenu for so when the user does a right click - there are options they can select. The question is : In order to create the PopupMenu, I created a menu for my form and then made parent for the menu options disabled and not visible. When the form is...

How can I tell if a command button is being pressed and held in the down position ? Thanks in advance, KFlasph

I am running a stored procedure through my Data Environment in Visual Basic 6. The first time I call the stored procedure in my program : DE.Connection1.dbo_mystoredprocedure dateParam1,dateParam2 dateParam1 = '05:00:00 AM' dateParam2 = '05:00:00 PM' I get back the results I expect. Without...

I have tried several HUNDRED times to do this but I can't figure out how ! I have created charts in an excel spreadsheets and want to go back after I have create them all and add some more information ( Rectangles with colors for my own created legends ). How can I loop through each of my...

Is there a way to modify/add information to the legend on a chart. I have created a chart and have change the column color based on the value the column is based upon. I would like for the legend to display the colors and what they mean. Is this possible? Thanks in advance.

Good morning, I have a data enviroment set up in my VB6 project with a stored procedure that I am calling within a form in the same project. The stored procedure that I am calling passes four values and returns two. Example: Create procedure upDateTable (@intValue1 int, @sValue2 char(6) output...

I am trying to create a stored procedure to look for information in specific fields. I am trying to do this by creating a parameter for each field. Parameters passed: @strField1 as varchar(20) @strField2 as varchar (20) @strField3 as varchar (20) Values that can be passed: --For testing...

I have a program that calls another program with a Shellexecute command. The second program runs in the background while the other program is still running and prints reports if needed. When the reports from the second program are printed - the printer dialog box is display and the first program...

I have a form that uses pageframes. On one of the pageframes depending on the users selection, I add a class grid. In the refreshing of the data, I release the form but sometime the grid has not been added so I get an error. How can I tell if my grid is in use? Thanks in advance, Kflasph

I am trying to write my first Flexibility program. I am modifiying the second page of the Voucher form under AP and I need to know how I can tell if the user selects the second page or if it has focus. Any ideas? Kflasph

I am interested in using the Flexibility package in Macola but I have no idea on how or where to start. Any suggestions? Thanks in advance! KFlasph

I trying to do a multiple sort using VFP and Excel. Here is my code: oExcel=Createobject('Excel.Application') oBook=oExcel.Workbooks.Open("C:\warranty.xls") oexcel.visible=.t. oExcel.Application.Cells.Select...

I don't know if this is even possible to do but here it goes. I have to write a program (via VFP 6) that shows if information in the table has been filled by the user. Using a treeview, the user wants to see if the field has information - show the field name in green, if not show the field name...

I am trying to print to a Zebra printer using the command SET PRINT TO COM1 SET PRINT ON and then I pass the printer commands. When I use the SET PRINT ON command, I get an error that the printer is not available. I think that my problem may be the baud rate because I can print a test page from...

My company currently runs both Visual FoxPro(6) and Dos Foxpro. We have many tables that are used (updated,read,etc) in both formats with no problems. I have a table that is zapped every night and rebuilt using DOS that I have to replace information in. I wrote a program in Visual to do this...

Is there any way to capture the user id and password (maybe through textboxes) and use a netapi or anything to verify to check if they are correct? KFlasph