What is MSSqlServer 2000's Bigint in powerbuilder 9.0.2?

how does the sqlserver 2000's bigint map to powerbuilder's datatypes?

Long? 


0
Cfauvel
8/9/2005 3:10:39 PM
sybase.powerbuilder.general 62418 articles. 19 followers. Follow

3 Replies
973 Views

Similar Articles

[PageSpeed] 25

longlong
A standard datatype that is a 64-bit signed integer in the 
range -9223372036854775808 to 9223372036854775807.


"Cfauvel" <TheFauvels@verizon.net> wrote in message 
news:42f8c76b$1@forums-2-dub...
> how does the sqlserver 2000's bigint map to powerbuilder's datatypes?
>
> Long?
> 


0
Chris
8/9/2005 3:47:39 PM
thanks...I think the datawindow may have an issue.

I have two apps, both built on pb9.0.2, one uses the native database driver 
for sqlserver, and the other uses the ole-db driver.

after I've created the DWs and look at the columns' data type LongLong is 
not an option.

I kinda expected that on the DWs built while connected using the native 
database driver, but not while connected using the ole-db driver.


The datatypes I have available for each column are:
String
number
decimal
date
datetime
time
long
ulong


My problem is this.
we want to change the Primarykey of a table to be sqlserver BigInt.

My app needs to retrieve this field as one of many fields in my DW, and when 
a user doubleclicks on the row, it populates a variable of type LongLong, 
and calls a popup window passing in this large number, retrieves the data 
based on this large PK.

I've created a test table test_table (pk_id bigint, mydate varchar(50)  )
populated it with the following

9223372036854775800 first peice of data
9223372036854775801 second piece of data
9223372036854775802 third piece of data


Created a stored procedure to retrieve both fields for one record based on 
the PK_id.

Created the DW based on the stored procedure and get the PK_id, being 
automatically mapped to PB datatype Decimal {0}

tried to retrieve one record using the id 9223372036854775800 and get the 
following error.

Select Error: Error Converting data type float to bigint.

Reconnected to the DB using oledb.
re-created the dw based on same procedure and got the Pk_id mapped to 
decimal{18} this time

When I try to retrieve the record for 9223372036854775800, I get the 
following error:

Select error:SQLSTATE = 22018
Microsoft OLE DB Provider for SQL Server
Error converting data type float to bigint.

I'm starting to think that this thread should be started anew in either the 
DW section or Database connectivity section...what do you think

Here are the results for PB10
Created the DW based on the stored procedure and get the PK_id, being 
automatically mapped to PB datatype Decimal {0}

When I try to retrieve the record for 9223372036854775800, I get the 
following error:

Select error:SQLSTATE = 22018
Microsoft OLE DB Provider for SQL Server
Error converting data type float to bigint.

Other interesting things.
if I retrieve  by this id , 922337203685477580, I don't get an error, but I 
also don't get any data expected.

here is a matrix of what ids do retrieve from the DB using PB10.0 , 
connected via OLE_DB

pk_id                                mydata 
canretrieve
--------------------           -------------------------------------------------- 
 ----------- 
9223372036854775800      first peice of data 
0
9223372036854775801      second piece of data 
0
9223372036854775802      third piece of data 
0
922337203685477580       fourth piece of data 
0
1                                         fifth piece of data 
1
2147483647                       long data type 
1
21474836470                  10times more than long 
1
214748364700                 100 times more than long 
1
2147483647000                1,000 times more 
1
21474836470000               10,000 times more 
1
214748364700000              100,000 times more 
1
2147483647000000             1,000,000 times more 
1
21474836470000000            10,000,000 times more 
1
214748364700000000           100,000,000 times more 
1
2147483647000000000          1,000,000,000 times more 
1
222337203685477580           some number 
0
212337203685477580           some other number 
0
92233720368547758            real big number 
0
22233720368547758            some number minus trailing 0 
0
21233720368547758            some number with second digit = 1 
0
2223372036854775             some number minus trailing 2 digits 
1
9223372036854775             real big number minus trailing digit 
0
214748364700000001       100,000,000 times more + 1 
0
214748364700001              100,000 times more + 1 
1
2147483647000001             1,000,000 times more + 1 
0
21474836470000001        10,000,000 times more + 1 
0
214748364700009          100,000 times more + 9 
1

(27 row(s) affected)



I don't get why I can retrieve data for 2147483647000000000, but not for 
2147483647000001


I think there is a bug somewhere.

"Chris Keating (iAnywhere Solutions)" <Spam_NoThanks_keating@iAnywhere.com> 
wrote in message news:42f8d017$1@forums-2-dub...
>
> longlong
> A standard datatype that is a 64-bit signed integer in the 
> range -9223372036854775808 to 9223372036854775807.
>
>
> "Cfauvel" <TheFauvels@verizon.net> wrote in message 
> news:42f8c76b$1@forums-2-dub...
>> how does the sqlserver 2000's bigint map to powerbuilder's datatypes?
>>
>> Long?
>>
>
> 


0
Cfauvel
8/9/2005 7:56:14 PM
Per sybase - bigint is not supported

http://groups.google.com/group/sybase.public.powerbuilder.database/browse_thread/thread/acd85791d5720716/e90deab7c6d32820?lnk=st&q=bigint++group:sybase.public.powerbuilder.*&rnum=2&hl=en#e90deab7c6d32820


0
Scott
8/10/2005 12:55:05 PM
Reply:

Similar Artilces:

Datawindow's Date argument with PowerBuilder 8.0.1 and Oracle 9i 9.2.0.1
Hi, there: Does anybody know how to pass datetime type data from client side to server side in the datawindow? Can anybody recommend a good book about how PowerBuilder deals with Oracle, datawindow, embedded SQL? Thanks in advance. PB DateTime data type corresponds to the Oracle Date type. You can set a DateTime variable using constants, or use the Date function to make a Date from mm, dd, yy and DateTime function to convert it. What are you not finding in the PB help and online books? "sybase.working" <sybase.working@yahoomail.com> wrote in message news:eYB...

PowerBuilder 9.0 and PowerBuilder 10.0
Hello NG ,,, I have a strange problem , installed both versions of PowerBuilder on the same machine having Windows XP. under Program files\Sybase9 - > PB9.0 was installed . under Program files\Sybase10- > PB10.0 was installed, I was working on XML workspace in PB9.0 where in the library list PBDOM90.PBD was included. By mistake , I opened the same workspace in PB10.0 and the application was migrated completed. Later coming back to PB9.0 and opening the same workspace , found that , in the system tree PDB files has zero object, It is not showing anything and the appl...

Powerbuilder 9.0 vs. Powerbuilder 8.0
What is the difference in Powerbilder 9.0 and 8.0? I would like to point out that the Appeon newsgroup is monitored by Sybase and Appeon engineering staff who are very knowledgeable about Appeon issues. Question that are purely PowerBuilder-related are best answered by the staff and users of the PowerBuilder newsgroup: sybase.public.powerbuilder.XXXX. Please post to the appropriate newsgroup so you receive the help you desire. Thanks, Julie Jiang Appeon Corporation <dburris@onesolution.com> wrote in message news:40589011.2717.846930886@sybase.com... > What is the diffe...

2.0.0.3 Says it found new version, but it's 2.0.0.2
The Updated version dialog pops up and says the latest version is 2.0.0.2, but I'm running 2.0.0.3! I went ahead and did the update, and sure enough, I now have 2.0.0.2. And when I check for updates, it says there are no new versions. Did Mozilla do this on purpose? Is this happening to anyone besides me? jishcat@gmail.com wrote: > The Updated version dialog pops up and says the latest version is > 2.0.0.2, but I'm running 2.0.0.3! I went ahead and did the update, and > sure enough, I now have 2.0.0.2. And when I check for updates, it > says there are no new...

The Complexity and Effort to Upgrade from PowerBuilder 5.0 to PowerBuilder 9.0
All, I am looking for any information you would have on the Complexity and Effort to Upgrade from PowerBuilder 5.0 to PowerBuilder 9.0. We are scoping out initial effort estimate documents and workplans. thanks- Brian I would start by searching this ng. Many folks have replied to questions regarding migrations from 8 to 9, 7 to 9, 6 to 9 etc. The notes may not answer all your questions but still should give you some valuable insight HTH Greg <Brian Hauss> wrote in message news:40c09b93.4a25.1681692777@sybase.com... > All, > I am looking for any information y...

Powerbuilder 9.0 Migration from powerbuilder 7.0.3 problem
Hi all, i was trying an migrate an powerbuilder 7.0.3 application to powerbuilder 9.0(PFC BASED APPLICATION (PFC objects version PB 6.5) ) during migration i am getting this error. tcmborrower.pbl(w_cursor_check).w_cursor_check.open.2: Error C0163: The definition of referenced global variable sqlca was improperly compiled in object trcomps Did anybody faced this kind of error? Thx Ashok JPMORGAN ---== Posted via the PFCGuide Web Newsreader ==--- http://www.pfcguide.com/_newsgroups/group_list.asp First error message which i got during the migration is : tcmappl.pb...

Your most recent version of Firefox, 2.0.0.9 has downloaded several times to my computer and to my wife's computer. #2
Name: K. Gilligan Email: kgilliganatpoldotnet Product: Firefox Summary: Your most recent version of Firefox, 2.0.0.9 has downloaded several times to my computer and to my wife's computer. Comments: The program that looks for up-dated software doesn't seem to recognize that this IS the latest version. (My wife's computer is a Mac PowerBook G4 with a non-Intel processor. Mine is a Power Book with an Intel Processor.) Now that I've sent this, it appears that the new program is not installing correctly, because it lists the Firefox version as 2.0.0.7. ...

Any issues with App's deployed with PowerBuilder 9.0.1(Build 6533) in Windows Server 2003.
Since PowerBuilder(9.0.1 Build 6533) provides limited support with Microsoft Windows Server 2003 operating system, we want to know if there are any known problems before deploying our PB apps in the Microsoft Windows Server 2003 operating system. Any info is really appreciated. Thanks. ...

I have 2.0.0.16 but it tells others it's 2.0.0.6!!!
Help > About Thunderbird says I have 2.0.0.16. However, the MR extension's View MyConfig says 2.0.0.6!! What gives? How do I correct this? Uninstall and reinstall? What about the profile folder? Thanks. Pete Holsberg wrote, On 18/09/08 21:48: > Help > About Thunderbird says I have 2.0.0.16. > > However, the MR extension's View MyConfig says 2.0.0.6!! > > What gives? > > How do I correct this? Uninstall and reinstall? What about the profile > folder? > > Thanks. I don't use MR extension but most probably is reading thi...

2.0.0.17 seems its not available through 2.0.0.16's update !
Name: Ed Product: Firefox Summary: 2.0.0.17 seems its not available through 2.0.0.16's update ! Comments: Why is it that with 2.0.0.16 I can't update to 2.0.0.17, I see 2.0.0.17 on the FF2.0 website, when i check for it in FF2.0.0.16 I get "No Updates Found"!. I don't want a response please just look into this, thanks !. Browser Details: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.8.1.16) Gecko/20080702 Firefox/2.0 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if y...

PowerBuilder 7 and Oracle 9.2.0.8.0 version
Hi, We have a customer who have among 40 legacy systems in PowerBuilder 7 and using Oracle8i, release 8.1.7.4.0. Now their database's team want to upgrade their database to the version 9.2.0.8.0 of Oracle, but before this we need to know if the version 7 of PowerBuilder can work with Oracle 9.2.0.8.0 Somebody know if is it possible? Hi Leonardo; 1) WOW ... O9i is no longer supported by Oracle. Why would they want to use that obsolete DB software? 2) I believe that PB 7 only supported 8i - so you would have to stay with that OCI level. The O8i interface should still ...

powerbuilder 9.0 Build 5507 'Unable to open this project'
When I try to compile a new project with powerbuilder 9.0 Build 5507 I get the message 'Unable to open this project because the add-on software that was used to create it could not be found. Perhaps this project was build on another system ?' Can anyone help me out? Thank you in advance ...

How to detect if the 'cancel' button on Acrobat Reader's PDF print dialog window has been clicked when using Acrobat Reader ActiveX control in Powerbuilder 9
Product name: Acrobat Reader V5.0, Powerbuilder V9 Operating System: Windows XP I have an Acrobat Reader's ActiveX control on my window application to present and print PDF files. The application was developed using Powerbuilder V9. I need to know if a user has just printed a file then save the printed date into a database. The user can click the 'Cancel' button on the print dialog window from Acrobat Reader to cancel the printing. In this case I won't update the printed date. How can I know if the user has clicked the 'Cancel' button to cancel the printing? ...

PowerBuilder 6.5 to Powerbuilder 9.0.1
Hello, We are having some issues while trying to upgrade from PB 6.5 to PB 9.0.1 The database is Sybase .I was hoping if you could post in any usergroups Background: There is a window w_child inherited from w_parent.The datasource of this dw_1 is a Stored Procedure that runs in Sybase ASE 12.5 In ue_1 of w_parent there is a dw_1.retrieve(arg1,arg2). ue_1 of w_child extends ue_1of w_parent. In ue_1 of w_child the code checks the condition dw_1.rowcount() >0 based on which it decides on the execution flow. Issue: While running the application, no rows are getting re...

Web resources about - What is MSSqlServer 2000's Bigint in powerbuilder 9.0.2? - sybase.powerbuilder.general

PowerBuilder - Wikipedia, the free encyclopedia
PowerBuilder is an integrated development environment owned by Sybase , a division of SAP . It has been in use since 1991, peaking around 1998 ...

Sybase PowerBuilder tool readied for Microsoft's .Net
... Win32 or newer style .Net development After several years of work, Sybase is ready to deliver on the final step in its plan to move PowerBuilder ...

Jim O'Neil (@jimoneil) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Open Directory - Computers: Programming: Languages
about dmoz - dmoz blog - report abuse/spam - help the entire directory only in Programming/Languages Description Top : Computers : Programming ...

The HP Booth Staff (Goons) Owe Me an Apology
... when you might need to use it. For instance, when I was in the WinRunner world there were plugins for driving terminal emulators and powerbuilder ...

Contact Us - Sybase Inc
Thanks for visiting the 主页 section of Sybase.com. Here you will find information about Contact Us. For more information about Business Intelligence, ...

热门搜索 - 我的异常网
... 我的异常网 » 热门搜索 sdpnet2 移动【A111】其它用户原因鉴权失败,是什么意思啊 http:// 192.168.1.102:22578 本网站服务器位于美国,受美国法律保护 MiniUI js 破解 http://192.168.1.103:8080/ powerbuilder ...

Mobile app security: Always keep the back door locked
The best way to keep mobile apps safe is to secure the services they connect to.

10 Tech Skills That Will Instantly Net You A $100,000+ Salary
... that let's developers run Java applications. Java is highly popular language for writing web apps and custom enterprise apps. No. 8: PowerBuilder ...

Top Ranked Articles
Top Ranked Articles - Free source code and tutorials for Software developers and Architects.; Updated: 23 Feb 2013

Resources last updated: 12/9/2015 1:10:32 PM