My database is at an inconsitent state, I am not sure if I should restart computer. I just created it from a backup. The database seems to be working fine but am unable to create a new backup.
Have I missed a process after the backup in order to remove the current state from "Inconsistent"...
I have the backup image but cannot figure out how to restore the image to a new databas? I tried to create an empty one but failed. Can this be done, does the backup have the table structures? I am lost any help would be greatly appreciated.
From VFP 8.0 I have opened an excel spreadsheet insert data and formated the sheet, all which I have done effortlessly by copying the VBA macro code in VFP and tweaking it here and there.
Now I want to save the spreadsheet with a name but can not do it I tried XLApp.WorkBooks.saveas() but I...
Why does this not work?
This.RemoveItem(this.ItemIdToIndex)
I know the above is wrong but I figure this will tell you what I am trying to do. I have this in the DBLClick method.
Here is an easy one that I can't figure out.
I am using a listbox object and have the multiselect set to true.
Now I want to use the multiple selection in a query. For example:
Select * from mytable where mfield in ('a,b,c,d')
Proble: how do I access the array or variable that contains the...
I tried to pass a variables to a stored procedure on MSSQL however it does not work. The code looks like this. Anyone have ideas?
=SQLEXE(MyConnection,"myproc(var1,var2)")
I created an array that populates the items for a C0ombo box. However I would like the user to have a selected item to be selected when the screen intializes.
I tried thisform.listitemid=3
Any ideas.
Thanks
I have read every thread on this subject. This is quite frustrating. In my grid I have one column that has a dollar amount. I want it to be red if negative or black if >= o.
I tried "IIF(amount<0, RGB(255,0,0),RGB(0,0,0) )" in the dynamicforecolor property but it does not work...
This does not work in foxpro, for those who know what I am trying to do, your help would be appreciated.
UPDATE table_1;
SET field_1= (SELECT field_1;
FROM table_2;
WHERE table_2.key=table_1.key)
Thanks
I am using a grid that is reading a view set to optimistic buffering.
I want to warn the user that the record will be deleted when the delete column of the grid is tagged.
However I do not know how to programatically un-delete the marked grid. I tried recall but it does not work. The ideal...
I am killing myself trying to change the color of the command button in my form. I have read all of the FAQ and countless pages help documentation.
I want to make my command button white.
any help would be apreciated
I am trying to use the update command to update a field with data from another table.
example:
update mytable1 set field1 =(select field1 from table2 where mytable1.key1=mytable2.key1)
Of course the above will not work, just trying to get accross what I am trying to do.
Thanks
I am trying to update a field of table1 with a field from table2. something like this..
Update table2 set field1 with (field1 of table2) both tables have a common key to join
Any help would be appreciated
I am unable to change the back color of the the _topform from the subclass that is created with app wizard. It only uses my change when the screen is refreshed.
Any help?
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.