datenisis's articles:

Items(11) /2 Next >> Last >|

SQL syntax for joining tables from multiple Databases in Pervasive? 1 235 (7/10/2007 7:15:58 PM) comp.databases.btrieve What is the SQL syntax for joining tables from multiple Databases in Pervasive? Thx. ... datenisis

Append text to existing field on Update 1 221 (2/2/2007 1:16:53 AM) comp.databases.btrieve I'm trying to append new text on a field using the concat function. On the Set statement I use something like this: Set Field = Concat(Field,'ABC') And when I check the results 'ABC' wasn't appended to . Wh... datenisis

Refresh Report Error: VB .net + CR + Pervasive 1 207 (9/19/2006 5:12:23 PM) comp.databases.btrieve I have gotten no response on the crystal vb forum so I'm trying my luck here: I get this error if I refresh the report programatically or manually in the crystal report viewer in my app: "Failed to load data... datenisis

How to Increase Performance on Crystal Reports over joins on Betrieve Tables 2 220 (8/31/2006 6:21:07 PM) comp.databases.btrieve My Crystal Report has joins between 3 tables and I noticed that it slows down considerably towards the end of the query when I preview the data. How can I make it faster? I do not want to create a supertable ... datenisis

Inser Trigger problem #3 5 185 (6/29/2006 10:49:05 PM) comp.databases.btrieve I've created an insert trigger that works if I add records manually using PCC. But when I use our accounting app to insert a new record in the same table the trigger doesn't fire. Thoughts? ... datenisis

Inser Trigger problem #2 0 180 (6/29/2006 10:48:54 PM) comp.databases.btrieve I've created an insert trigger that works if I add records manually using PCC. But when I use our accounting app to insert a new record in the same table the trigger doesn't fire. Thoughts? ... datenisis

Inser Trigger problem 0 159 (6/29/2006 10:48:49 PM) comp.databases.btrieve I've created an insert trigger that works if I add records manually using PCC. But when I use our accounting app to insert a new record in the same table the trigger doesn't fire. Thoughts? ... datenisis

Cannot see new table 1 149 (6/28/2006 11:01:10 PM) comp.databases.btrieve I can't see newly created tables from clients connected to it. I can see it on the server. What's going on? Is it that the DDFs didn't update itself properly, if so how do I resolve this? ... datenisis

Can't see tables after using create database 2 197 (6/5/2006 5:16:27 PM) comp.databases.btrieve I have existing ddf and btr files in a direcotry and I wanted to connect to them using the PCC. I used the create database wizard, and used advanced settings and created a new database name. The database was ... datenisis

Linked Server and OLEDB Problem 3 235 (1/17/2006 5:42:28 PM) comp.databases.btrieve I was able to set up a linked server from MS SQL 2000 to pervasive sql 2000 but when I run the sp_catalogs command on the query analyzer I get the following error message: Server: Msg 7399, Level 16, State 1,... datenisis