Sure,
But I doubt you need all this indexes all the time.
If you need an index JUST for report use SQL Select into cursor and order the information there.
And the base the report of the result cursor.
Borislav Borissov
VFP9 SP2, SQL Server
or
'Q' +
CAST(DATEPART(qq, dbo.JourneyHeader.JourneyDate) AS VARCHAR(1)) +
' - ' +
CAST(DATEPART(yy, dbo.JourneyHeader.JourneyDate) AS VARCHAR(4)) AS QtrYear...
Put 'Q' BEFORE DATEPART(qq, dbo.JourneyHeader.JourneyDate) AS VARCHAR(4))
CAST('Q'+DATEPART(qq, dbo.JourneyHeader.JourneyDate) AS VARCHAR(4)) + ' - ' + CAST(DATEPART(yy, dbo.JourneyHeader.JourneyDate) AS VARCHAR(4)) AS QTRYEAR,
Borislav Borissov
VFP9 SP2, SQL Server
IF EXISTS(
EXEC sp_executesql N'DROP FUNCTION xxxxx'
IF NOT EXISTS(..
EXEC sp_executesql N'CREATE FUNCTION xxxx ...
'
NOT TESTED!
Borislav Borissov
VFP9 SP2, SQL Server
Export whatever you want to run in separate method and run this in INIT of Form1.
Then add a property in this form named RUNNED_FORM and set assign method
In Init of this Form:
...
thisform.MethodThatYouWantToRun()
...
There where you run Form2
DO Form2 NAME thisform.RUNNED_FORM LINKED...
I doubt that you want this command.
This code just check the result from the current record of the table and acts according to this result for ALL records no matter what is the values of the fields in other records;
Maybe this?
replace ALL ndcms WITH (nqtyp+nqtys+nqtyn)/1000 *...
Nope,
ORDER BY works only for SQL result set.
It didn't works for the records you add after.
If you want ordered curosr with all inserted records you must index the resulted cursor.
Also you can use UNION and then ORDER BY but that will not work if you add more records after you get the result...
The whole GRID is readonly. That is why columns are too, no matter what you do.
BTW you can access columns through Coluimns property of the Grid
For lnCountCol = 1 To lnTotalCol
Thisform.container1.grid1.Columns(lnCountCol).ReadOnly = .F...
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.