Discussions tagged DataType
How to know query datatype
- How-to
- Last updated 4 months ago
- Mario Francisco Celleri replied 3 months ago
Hi guys;
Thanks for your time. I need to know what type of data retrieve a query; when use a datawindow.
I put into context what require or intend to do.I have several queries to make to a database; on several tables, with different types of dat...
I have multiple datawindows that call Oracle stored procedures. Each procedure returns only ONE result set. I'm finding in datawindow they do NOT like datatypes of NUMBER or LONG. I've been changing them to Decimal(0) yet I can't really say that's...
PowerServer - The Int64 type is not compatible with the data type of mapped property
- Resolved
- Issue
- Last updated 1 year ago
- David Xiong @Appeon replied 1 year ago
Hi,
I wanted to share the following situation, in case there is a solution for this.I'm using PB2022, build 1900 and the database is Oracle 19
I'm getting the error "The Int64 type is not compatible..." and below is an example of a situation where ...
SQL select from PowerBuilder returns only part of data
- Resolved
- Issue
- Last updated 1 year ago
- MARK APTEKAR replied 1 year 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 2 years ago
- Sivaprakash BKR replied 2 years 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 4 years ago
- Marcos Bolonha replied 4 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 5 years ago
- Roland Smith replied 5 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 5 years ago
- Roland Smith replied 5 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 6 years ago
- Rudolf Fürst replied 6 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