General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>No. You can programatically create views using your own syntax and force them into the DBC but I don't recommend it. If someone tries to edit the view using the view designer it may result in an error.
Thanks for the advice. It works now, but I have a method that runs in a combo on the form for search purposes that's giving me "Table has no index order set"
errors. Here's the code....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLOSE DATABASES
OPEN DATABASE ('c:\diamondaccounti\inventory')
if !used('intrancust')
use intrancust
else
select ('intrancust')
endif
SET ORDER TO stocknum
SEEK Thisform.Combo4.value
IF FOUND( )
Thisform.CHARGEPERKARAT1.VALUE = chgperkt
Thisform.MEASUREMENTS1.VALUE = measure
Thisform.Combo3.VALUE = cut
Thisform.Combo2.VALUE = colors..............
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
the error points out the line "SET ORDER TO stocknum". I made that field an index in the view...was that not enough?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only