V4MD error 5 and 8 problem

[Olaf Schmidtmann]

Maybe try to delete the index and rebuild it. I don´t have an idea for your
special problem (and I have to leave now) but for my mysterious Vale
problems it helped sometimes. - especially when the db had to survive some
crashes.

Cheers
Olaf

--
Olaf Schmidtmann
brainbits
online & cross media
mailto:os at brainbits.net / www.brainbits.net 

> -----Original Message-----
> From: Lee Swanson [mailto:lee at ibc.com.au]
> Sent: Thursday, January 30, 2003 3:17 AM
> To: Valentina Developers
> Subject: V4MD error 5 and 8 problem
> 
> 
> Hi,
> 
> I have ignored this problem for a while to work on other 
> things, but now it
> is mission critical... (my deadline is tomorrow...) I am developing in
> Director MX on pc.
> 
> I have the following query:
> 
> SELECT JOBS_6.Job_ID_6, JOBS_6.Job_Text_Names_6   FROM
> JOBS_6   ,
> JOB_INDUSTRY_LINKS_19    ,
> JOB_INTEREST_LINKS_22   ,
> WDEMAND_JOB_LINKS_26   ,
> LAREA_JOB_LINKS_24   ,
> STATE_INFO_9
> WHERE JOBS_6.Job_ID_6 = JOB_INDUSTRY_LINKS_19.JCLink_JobID_19
> AND JOBS_6.Job_ID_6 = JOB_INTEREST_LINKS_22.JCLink_JobID_22
> AND JOBS_6.Job_ID_6 = WDEMAND_JOB_LINKS_26.WDJ_Link_JobID_26
> AND JOBS_6.Job_ID_6 = LAREA_JOB_LINKS_24.LAJ_Link_JobID_24
> AND JOBS_6.Job_ID_6 = STATE_INFO_9.StInf_JobID_9
> AND Job_Text_Names_6 <> ''
> 
> When I run this query I always get an error. Sometimes it is 
> error 5 and
> sometimes error 8. I have run the query in ViSQL and It works 
> fine. If I
> remove two of the joins (it doesnt matter which ones) it works ok.
> 
> I have tried increasing the cache to 100 meg, but this 
> doesn't seem to help
> (it is now back at 10 meg).
> 
> Ruslan I know you will tell me to search the archive, and I 
> have done this.
> I have found a couple of people who had the same problem as 
> me, but the only
> sollutions I could find were related to inserting floats or 
> something else
> that I am not doing (or ruslan telling them to look in the 
> archive). I am
> not altering my database at all from director.
> 
> All my other cursors can be created without a hitch. This is 
> the only one I
> have a problem with.
> 
> Any help would be greatly appreciated.
> 
> Lee.
> 
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>