Discussions tagged DataType
SQL select from PowerBuilder returns only part of data
- Resolved
- Issue
- Last updated 3 months ago
- MARK APTEKAR replied 1 month ago
Hi, Using PowerBuilder 2019 R3 build 2703 with SQL Server version ? ( I know it is new. 'SELECT @@version' returns Microsoft SQL Azure (RTM) - 12.0.2000.8 Jan 12 2023 05:25:39 Copyright (C) 2022 Microsoft Corporation )
DBMS=ODBC
DBParm=Conne...
Re: Data type issue in Datawindow
- Resolved
- Issue
- Last updated 1 year ago
- Sivaprakash BKR replied 1 year ago
Hello,
Using PB 2019 R3 build 2703, PostgreSQL 11, Windows 10 [ Both computers ]
We created a datawindow using the following query [ not a real query ]
Select Cast(0 as decimal(17,3)) as billedquantity, Cast(0 as decimal(17,3)) as stockquantity, ...
PB x SQLite3 datatype columns issue
- Resolved
- Issue
- Last updated 3 years ago
- Marcos Bolonha replied 3 years ago
Hi,
We have a powerserver mobile project that use SQLite3 as a local DB. The tables has decimal datatype columns but when we create a new DW with that tables as a datasource the PB recognize that columns as a WVARCHAR and we can't use these columns ...
Hi Guru
How long can a 'string' field be?...
Read .NET DataTable on PowerBuilder
- How-to
- Last updated 4 years ago
- Roland Smith replied 4 years ago
Hi everyone, I have a .NET webservice that return an Structure with a DataTable datatype:
When I call the webservice from PowerBuilder I get the TypeResultQuery structure, but DT is determined as Any datatype for Powerbuilder:
I tried to create a...
How much memory is used by certain standard PB data types?
- Misc
- Last updated 4 years ago
- Roland Smith replied 4 years ago
How much memory is used by each of the following standard data types?
Date
Time
Datetime
Real
Double
Decimal
...
Different Metadata Types in Oracle 10 and 11
- Issue
- Last updated 4 years ago
- Rudolf Fürst replied 4 years ago
Hello,
We are missing several metadata types after the database change from Oracle 10 to Oracle 11. how can we add these? (Example: Timestamp)
tia...
- Page :
- 1