Search results for query: *

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

You can check what type is the drive with DRIVETYPE() function 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...

When importing go to field mapping and make this field varchar(max) Borislav Borissov VFP9 SP2, SQL Server

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...

How do you know which row is first and which is second? Borislav Borissov VFP9 SP2, SQL Server

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...

Did you set this program to be main? Borislav Borissov VFP9 SP2, SQL Server

DECLARE @Parts table ( PartId int, CreatedDate date, LeadValue int ) insert into @Parts(PartId,CreatedDate,LeadValue) values (1234,'20210703',5), (1234,'20211005',90), (1234,'20211105',50), (5981,'20211115',70), (5981,'20211203',60), (6070,'20211212',20)...

DECLARE @Parts table ( PartId int, CreatedDate date ) insert into @Parts(PartId,CreatedDate) values (1234,'20210703'), (1234,'20211005'), (1234,'20211105'), (5981,'20211115'), (5981,'20211203'), (6070,'20211212'), (6070,'20220108') DECLARE @CurrentMonth date SET...

If you use VFP 9 there is WITH (BUFFERING=.t.) hint. FROM tbl_source WITH (BUFFERING=.t.) Borislav Borissov VFP9 SP2, SQL Server

IF thisform.cboBatchType.DisplayValue= 'Pending GRN' && Display Value - Really??? UPDATE ACPGRN SET cGRN = 'Awaiting' ELSE UPDATE ACPGRN SET cGRN = IIF(ACPGRN.nPoQty>ACPGRN.nGrnQtyVal, 'Awaiting', Completed') ENDIF Borislav Borissov VFP9 SP2, SQL Server

That means no CASE is satisfied. As I said, DEBUG and see how this code is executed. Copy and paste lcSQL variable value and try to execute this statement in SSMS. Just replace thisform.txtFrom.Value and thisform.txtTo.Value with real values when you execute the statement. Borislav Borissov...

DO CASE CASE thisform.cboReportType.Value = 'Pending GRN' lcFldName = "dAdvanceDate" lcCrsName = "_Pending" lcTblName = "Acp_AdvancePayment" CASE thisform.cboReportType.Value = 'Completed GRN' lcFldName = "dPaymentDate"...

There is a tool named DEBUGGER. Just step on this and check what happens. What is the SELECT generated? Borislav Borissov VFP9 SP2, SQL Server

IF !EMPTY(thisform.cboReportType.DisplayValue) then lcFldName = "dPaymentDate" lcTblName = "Acp_FinalPayment" lcCrsName = "_Completed" DO CASE CASE thisform.cboReportType.Value = 'Pending GRN' lcFldName = "dAdvanceDate" lcCrsName = "_Pending"...