Welcome to the Calyx Software Message Boards where you can share ideas and solutions with other Calyx users! Calyx personnel including Tech Support, Development, QA, and Business Planning often visit these message boards unofficially to better understand our customers' needs. To submit your suggestions Click Here.
This discussion forum is a service provided by Calyx Software. Calyx Software does not endorse any particular point of view expressed in this forum or any information provided in it. The use of the information provided by other users in this message board is at your own risk.
Calyx Software Message Board
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      


12»»

Cardex Error Messages during SaveExpand / Collapse
Author
Message
Posted 1/5/2006 11:44:49 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 3/26/2007 9:34:11 AM
Posts: 22, Visits: 46
Just finished upgrading to 5.2 from 5.0, grandfathering in our existing settings (rather than having a default configuration overwrite things.)  Things seem to be running flawlessly. However, when I open an existing record in Cardex, make a modification and attempt to save, I get the message:

Cardex Error: No value given for one or more required parameters.

If I try to create a new cardex entry, after filling in all of the fields, and attempting to save and close, I get:

Cardex Error: Syntax error in INSERT INTO statement

Appreciate some help. Thanks.

Steve

Post #1859
Posted 1/5/2006 11:52:04 AM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 3:54:08 PM
Posts: 1,178, Visits: 9,173
is there any more data in the latter error?

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
Post #1861
Posted 1/5/2006 11:55:05 AM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 3/26/2007 9:34:11 AM
Posts: 22, Visits: 46
BetaFisch (1/5/2006)
is there any more data in the latter error?

Nope - that's it. When I click on the OK button, the window clears and the cardex view returns to it pre-editted state.

Steve

Post #1863
Posted 1/5/2006 12:10:32 PM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 3:54:08 PM
Posts: 1,178, Visits: 9,173
Have you ever opened this cardex in access?
is the cardex on a local or network drive?

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
Post #1868
Posted 1/5/2006 12:22:47 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 3/26/2007 9:34:11 AM
Posts: 22, Visits: 46
BetaFisch (1/5/2006)
Have you ever opened this cardex in access?
is the cardex on a local or network drive?

I may have in the past. However, it is more than likely I would have copied the database and accessed the copy to avoid any possible Access-like tweaking (knowing how Access operates.)  I am currently running Access 2000 on my computer, and may have only attempted to use it to generate a report.

The cardex database we are using is on the network.

Steve

Post #1870
Posted 1/5/2006 1:28:36 PM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 3:54:08 PM
Posts: 1,178, Visits: 9,173
take the attachment and rename it to pointcdx.mdb and put this in your cardex location, next run Point and open cardex use import to import your old cardex file.

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.

  Post Attachments 
PointCDX.txt (189 views, 112.00 KB)
Post #1875
Posted 1/5/2006 2:08:39 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 3/26/2007 9:34:11 AM
Posts: 22, Visits: 46
Well, I moved the old PointCDX.mdb file to the parent subdirectory, and copied and renamed the attachment from your post.  Launched Point, opened Cardex - no records visible - and used the File Import function. Browsed to the new file, and then received the following:

Cardex Error: Object reference not set to instance of object.

?

Steve

Post #1879
Posted 1/5/2006 2:33:08 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 3/26/2007 9:34:11 AM
Posts: 22, Visits: 46
Fixed the problem. Here is how I worked through it...

I restored the original Cardex file. Opened Point and exported the old database to comma-delimited format file. Closed Point. Renamed the original Pointcdx.mdb file, and copied your attachment and renamed per your instructions.  Then, opened up Point, and Cardex. Used the File import and things work like a charm.  Problem resolved.

Thanks for your help and quick responsiveness.

Steve

Post #1880
Posted 1/6/2006 6:40:52 AM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 3:54:08 PM
Posts: 1,178, Visits: 9,173
would it be posible for you to send my your cardex file so i can look into what was corupted?

Disclaimer:  This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.
Post #1893
Posted 1/10/2006 11:07:17 AM