Search results for query: *

Correct the slcust_trx table has no data. I tried you sample on two different pervasive databases A and B. Database 'A' is where it needs to work b/c that is where the slcust table is. Database 'B' is I just created for testing. You sample still didn't work in DB 'A'. But it worked just...

;insert into jwsdata1..slcust (customerid, description) values('test02','testing') --The trigger should fire after this statment-- ;update slcust set description = 'testing tested1' where customerid = 'test02' I have also tried changing the trigger to this: ;create trigger slcust_UPDATE AFTER...

Pervasive version: 9.50.077.002 Update: -------------------- first I found my error on my simple example. I was referencing old insead of new for an insert. CREATE TRIGGER test_insert after insert on test_trigger referencing old<---error is here> as n for each row insert into slcust...

I'm running Pervasive 9.5 after creating insert, update, delete triggers and testing them through PCC only the delete trigger fires. Right now i'm just testing the most simple triggers I can create. I have table A and B, all triggers are on table A and effect table B. I'm only using pcc or...

I was wondering if anyone knows of a way for one application to find (listen almost) when any application from the system try pops up a balloon message and respond to that balloon message.

Background: I'm trying to write a bluetooth cell phone application to allow a user to easily answer and make phone calls through the bluetooth widcomm stack to a paired cell phone. I know that you can already take calls from a cell phone by pairing with the head set service installed by the...

All of the tables that are linked to the main table I use for the report have left outer joins. Good idea though What it appears to be is that when crystal initially calculates where everything is to be printed it does take into account the white space that will later be suppressed. So, what...

I have a statement report in Crystal 10. First off, the report was grouped by Customer, apply to number, and date applied. The only problem with this is that all of the documents need to be in ascending order, not just inside the apply to number group. So, I created the main report to only...

Never mind I found my problem. I had the references added but I didn't check the box to import the Microsoft.Office.Interop name space which allows you not to have to type "Microsoft.Office.Interop." before your excel objects.

Hi, I'm trying to write a program to: 1)open an excel file 2)read and write some data to it 3)save and close the file I am stuck on part 1. I keep getting the error "Member not found. (Exception from HRESULT: 0x80020003 (DISP_E_MEMBERNOTFOUND))" on this line of code aWorkbook =...

DB Explorer - which isn't very user friendly Database Comparer - I like it a lot. it's intuitive to use if you have any sql and ODBC experience at all.

1) Yes PSQL is running on both servers. 2) I'm running it from a client 3) right now I'm using the Pervasive SQL Control Center (not to get off topic but if you could recommend a better interface please do) 4) The goal. we have a development system where I customized screen designs. Once the...

I am running Pervasive version 9.5. Does Anyone know how to run a query that can select data from two or more servers? Thanks.

Our VPN routers after an update solved the problem!

Me and a coworker of mine are running XP Pro with all windows updates installed, and PCanywhere version 11.0.1 build 764 and the same firewall configuration as well as all symantec updates. We go through the VPN to a location running the same Host Only PCanywhere version and build on W2k...