Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Problem
Message
 
 
To
15/08/2016 03:39:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01639454
Message ID:
01639469
Views:
90
>
>Create CURSOR tj02  (s_no N(7) ,vou_no c(10) ,Date  d(8),vou_type c(4) ,acc_code c(7),acc_name  c(40),;
>	drcr1  c(2) ,sales_r c(30),vehicle_no c(10),;
>	dr_amount N(10,2),balance N(10,2),vvou_no N(5),dd_amount N(10,2),ssno N(3))
>
Don't use VFP (and SQL Server) reserved words as a column name. Date is a reserved word. dDate would be a better name for the column. The index expression needs to be

index on acc_code + dtos(dDate) tag CodeDate
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform