By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,117 Members | 2,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,117 IT Pros & Developers. It's quick & easy.

Vo2Ado/MSDE Create Index problem

P: n/a
Hi,
i'm having a problem to create indexes.

STEP 1
-----------
Connection is OK (you can find the string at the end of the message)

Table ("Couleurs") creation is OK

STEP 2. Index Creation
---------------------------------
I'm trying to create an index on this table BUT the following code
does NOT work and my app does NOT return an error
1)
oConn:Execute("CREATE INDEX Appelations ON Couleurs
(COLORNAME)",adExecuteNoRecords,adCmdText)

or
2)
oCmd := AdoCommand{}
oCmd:ActiveConnection := SELF:oConn
oCmd:CommandText := "CREATE INDEX Appelations ON
Couleurs (COLORNAME)"
oCmd:CommandType := adCmdText
cbErr := ErrorBlock({|oErr|_Break(oErr)})
BEGIN SEQUENCE
oRs:= oCmd:Execute(NIL,NIL,NIL)
RECOVER USING uVOError
END
ErrorBlock(cbErr)

STEP 3 : a look at the results in the AdoCatalog
--------------------------------------------------------------------
Via Vo2Ado example "Explorer ADOX", i can see some index information.

The name of the index ("Appelations") is shown.
The column ("ColorName") is also shown...

There is an AdoIndex object but when i have a look at the properties
(Clustered,Primary Key,Unique and Fil Factor), the listview "Value"
column returns .........."The index does not exist"...

How can i solve this problem ?

Thank you
Guy Deprez, Belgium
----------------------------------------------
Connection String:
Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=False;
Initial Catalog=archdat;
Data Source=XP-MY094GEYUFG3\BcaSoftware;
Use Procedure for Prepare=1;
Auto Translate=True;
Packet Size=4096;
Workstation ID=XP-MY094GEYUFG3;
Use Encryption for Data=False;
Tag with column collation when possible=False
Properties :
Current Catalog : archdat
Multiple Connections : .T.
Reset Datasource : NIL
Enable Fastload : .F.
Active Sessions : 0
Alter Column Support : 501
Asynchable Abort : .F.
Asynchable Commit : .F.
Pass By Ref Accessors : .T.
Catalog Location : 1
Catalog Term : base de données
Catalog Usage : 15
Column Definition : 1
NULL Concatenation Behavior : 1
Connection Status : 1
Data Source Name : XP-MY094GEYUFG3\BcaSoftware
Read-Only Data Source : .F.
DBMS Name : Microsoft SQL Server
DBMS Version : 08.00.0760
Data Source Object Threading Model : 1
GROUP BY Support : 4
Heterogeneous Table Support : 3
Identifier Case Sensitivity : 8
Maximum Index Size : 900
Maximum Open Chapters : 0
Maximum Row Size : 8060
Maximum Row Size Includes BLOB : .F.
Maximum Tables in SELECT : 256
Multiple Parameter Sets : .T.
Multiple Results : 1
Multiple Storage Objects : .F.
Multi-Table Update : .F.
NULL Collation Order : 4
OLE Object Support : 33
Open Rowset Support : 8
ORDER BY Columns in Select List : .F.
Output Parameter Availability : 4
Persistent ID Type : 1
Prepare Abort Behavior : 2
Prepare Commit Behavior : 2
Procedure Term : procédure stockée
Provider Name : sqloledb.dll
Provider Friendly Name : Microsoft OLE DB Provider for SQL Server
OLE DB Version : 02.70
Provider Version : 08.10.9031
Quoted Identifier Sensitivity : 8
Rowset Conversions on Command : .T.
Schema Term : propriétaire
Schema Usage : 15
Server Name : XP-MY094GEYUFG3\BCASOFTWARE
SQL Support : 283
Structured Storage : 1
Subquery Support : 31
Transaction DDL : 8
Isolation Levels : 1118464
Isolation Retention : 0
Table Statistics Support : 3
Table Term : table
User Name : dbo
Unicode Locale Id : 0
Unicode Comparision Style : 0
Column Level Collation Support : .T.
Character Set Name : NIL
Sort Order Name : NIL
Current Collation Name : French_CI_AS
Integrated Security : SSPI
Password : NIL
Persist Security Info : .F.
User ID : NIL
Initial Catalog : archdat
Data Source : XP-MY094GEYUFG3\BcaSoftware
Window Handle : NIL
Locale Identifier : 1036
Prompt : 4
Extended Properties : NIL
Connect Timeout : 15
General Timeout : 0
Current Language : NIL
Network Address : NIL
Network Library : NIL
Use Procedure for Prepare : 1
Auto Translate : .T.
Packet Size : 4096
Application Name : NIL
Workstation ID : XP-MY094GEYUFG3
Initial File Name : NIL
Use Encryption for Data : .F.
Replication server name connect option : NIL
Tag with column collation when possible : .F.
Autocommit Isolation Levels : 4096
Quoted Catalog Names : .F.
Allow Native Variant : .F.
SQLXML Version : SQLXMLX
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.