I use informix database ,I want to know how to get the server time on informix server in powerbuilder
Try to use CURRENT in embedded SQL for select one row, f.e.
SELECT CURRENT INTO :ldt_cur FROM systables WHERE tabid = 1 ;
lt_cur = Time(ldt_cur) // or use
ls_time = String(ldt_cur, 'hh:mm:ss')
select current date into :ldtDateTime from SomeTable ;
...two informix server connect to powerbuilder database profile
Please give me some feedback as it is real urgent.
Can I connect to 2 informix database but from the different
I am using Powerbuilder 5.04 and Informix SetNet32.
I got an error when doing so as the INFORMIXSERVER don't allow me
connecting to another database from other INFORMIXSERVER. The error message
that I got
is "cannot connect to database server(server name)..."
informix error code -930
--setnet32 enviroment setting(informix server)
make default server = domeic_oltcp0 <-- powerbuillder database profile
another infor...I cant insert data into a Informix database using DataWindow Painter
I'm using PowerBuilder 5.0 with 5.0.02 bug fix and Informix DataBase.
I have a table with two columns, one is a decimal data type and the other
one is a Char(30). The first column (that with decimal data type) is the
primary key. At the data window Painter when I add a line and try to save
changes, I receive an error message: "Changes between retrieve and update".
And I can't understand why this kind of error only happens when I'm using
Informix with this column (decimal data type) as primary key. When I use
other column as primary key, or when I use SQLAnywhere to...Version of PowerBuilder (ref: Creating database for PowerBuilder)
I'm using PowerBuilder v8.0 and would like to create a
notification system for my practiculum project. I'd like to
use Access to create the database. Please enlighten me on
what should I create (e.g. tables, queries) for the usage of
Don't double post, it's bad etiquette.
Unless you have a very good reason to do so, we recommend you don't use
Access. Use SQL Anywhere instead - it's more stable - and a far better
database in my opinion. PowerBuilder (enterprise) supports just about every
database out there, so if you...Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information for a debug run. Will apprecaite any
DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~",
~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~",...Powerbuilder Datawindow
Can you do a Datawindow in VS 2005 without using
Datawindow.NET just by using common controls i.e DataGrid
What would you use the DataWindow for then? To retieve the datawindow
into a datastore and then attempt to use it to populate the DataGrid?
I've heard of people who want to have their cake and eat it too, but
it sounds like you want no cake but you want to eat it...
On 20 Feb 2007 23:42:31 -0800, Chris Ceniza wrote:
>Can you do a Datawindow in VS 2005 without using
>Datawindow.NET just by using common control...Powerbuilder datawindow
I'm importing a some data into my application. The way I do this is to
insert a the rows into a datawindow and then do an update() on the
If a row in the database allready exists with the same primary key as I have
inserted into the datawindow, what will happen then? Will then datawindow do
an update or will I get an error?
I'm doing this on a datastore object. How can I get an errormessage from the
datastore? I have tried the errormessages and codes from the transaction
object (sqlca.sqlerrtext and sqlca.sqlcode).
> If a row in the...Informix and PowerBuilder again!!
For some strange reason which I don't seem to grasp yet, I can connect to my
informix database from my development computer with no hassle, but when I
try to connect from my clients computer, the following message appears:
SQL Error: -25556 Invalid sqlhosts file format
The client computer has all the necessary files (Powerbuilder DDk 6.0,
Informix client, and the application). The informix DDK files are copied in
the path of the computer. The client computers are running Windows NT 4.0,
and the applicationc is being developed in Powerbuilder 6.0 and the informix
Database is ver...datawindow
I have a question:
Let's say I populate a datawindow, and then I make process/modifications to
the data in the datawindow... where is the modified data stored? is the
datawindow contents in PC memory? or is it stored on some temporary table on
my database server?
Really my questions are: is the process of the datawindow data isolated from
the database? How? In which extent? Is the dw.Retrieve() and dw.Update() the
only points where I should care about the underlying database being used?
Look through the datawindow programmers guide...it answers b...Select in Powerbuilder Database painter WORKS but does NOT in Powerbuilder run mode.
I have enclosed the actual information from a debug run. Will apprecaite any
DataWindow.Table.Select="SELECT DISTINCT ~"inv_dtl~".~"inv_id~",
~"inv_dtl~".~"sugg_price~", ~"inv~".~"vend_id~", ~"inv~".~"style~",
~...DataWindow This, DataWindow That...
Blah blah blah
You've heard it enough that you don't even want to comment on how many
....but it can't be enough anymore...can it?
This from one of our colleagues
(and yes my apologies for taking it out of context)...
"...PB covers all you need to do that in ONE Tool. This
includes Windowprogramming ( meaning the interface to the user:
Windows, Sheets, diallougeboxes, etc.), Database operability AND
Reporting! Well, I see als well as many other PB users that some of
the implementations and features PB offers are improvable. But thi...Powerbuilder and Informix
When we are connecting from Powerbuilder 5.0/6.0/6.5 on Win 95 to
INFORMIX 7.1 or
7.3 on SCO-UNIX, and trying to update a date field from dw painter, we
are getting "Invalid month in date format". We are using the
format in edit mask of the field in the dw and "dd/mm/yyyy" in Control
Panel settings in Win 95 and DMY4/ in DBDATE for Setnet32.
We can update using "dd/mm/yyyy" format from the DBAdmin painter thoogh.
Can u please suggest what can be going wrong.
The dw update works fine on SCUNIX Informix 5.1.
Any help w...connectivity problems from PB to informix database using informix client SDK
I have installed informix client sdk version 2.81. I tested thru the
informix i login demo and I am able to connect. I tried to set my db
profile thru powerbuilder. I select db profile menuoption from
powerbuilder. WE I got the list of all the databases type available, I
selected IN9-informix-v9 and then selected new. I get the following error
"The procedure entry point InfxRegsqlHostsEx2 could not be located in the
dynamic library iregt07b.dll".
If anyone can hep me with this problem , I will be grateful.
This might be caused if the ...Is PowerBuilder 10.0 support Informix 9.4 or Informix 10.0 version
Jan 24, 12:58 pm show options
From: "nirav...@yahoo.com" <nirav...@yahoo.com> - Find
messages by this author
Date: 24 Jan 2006 09:58:13 -0800
Local: Tues, Jan 24 2006 12:58 pm
Subject: Is PowerBuilder 10.0 support Informix 9.4 or
Informix 10.0 version
Reply | Reply to Author | Forward | Print | Individual
Message | Show original | Remove | Report Abuse
I read PowerBuilder 10.0 release note. It says that
supports the following versions of Informix: 9.0, 9.1, 9.2,