December 4, 2008 08:20am pst

02.11.2004 at 08:24AM PST, ID: 20881258

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.0

CONVERT PB APP FROM ASA TO SQL SERVER 2000

Asked by pemurray in PowerBuilder Programming Language

Okay, so I get all done with my app and then someone wants to move it onto SQL Server 2000 (Sorry Sybase).

I use PowerDesigner, re-generate the tables, create an odbc connection to the database and update the open even of the application. Basically, it seems to work!!

But in that nasty date oriented query that Namasi was helping me with, I am getting SQL STATE 37000 errors:

I was using DATE which is not supported by SQL Server.

I changed the retrieval arguments from DATE to DATETIME.
I changed the variable in the script from a DATE to DATETIME.
I even changed the editmask controls from a DATEMASK! to DATETIMEMASK!

When I go into the datawindow and manually enter the query arguments, the dw works fine. But I am still having trouble running the app.

Here is where I currently am with the code:

Any help would be greatly appreciated.

Best regards,

Paul

int inprocess_int
int onhold_int
int targeted_int
int completed_int

string inprocess
      if cbx_inprocess.checked then
            inprocess = "In Process"
            if (inprocess="") then
                  inprocess_int = 0
            else
                  inprocess_int = 1
            end if
      end if

string onhold
      if cbx_onhold.checked then
            onhold = "On Hold"
            if (onhold="") then
                  onhold_int = 0
            else
                  onhold_int = 1
            end if
      end if

string targeted
      if cbx_targeted.checked then
            targeted = "Targeted"
            if (targeted="") then
                  targeted_int = 0
            else
                  targeted_int = 1
            end if
      end if

string completed
      if cbx_completed.checked then
            completed = "Completed"
            if (completed="") then
                  completed_int = 0
            else
                  completed_int = 1
            end if
      end if

if (inprocess_int + onhold_int + targeted_int + completed_int = 0) then
      messagebox("Error!","You must select at least one Status Option")
      return 1
end if

datetime startdate
datetime enddate

em_start_date.GetData(startdate)
messagebox("GetData Results:Start Date",string(startdate))

em_end_date.GetData(enddate)
messagebox("GetData Results:End Date",string(enddate))

if (date(enddate) <= date(startdate)) then
      messagebox("Error!","End Date cannot be equal to or less than Start Date.")
end if

dw_1.retrieve(inprocess,onhold,targeted,completed,startdate,enddate)

Start Free Trial

Keywords: CONVERT PB APP FROM ASA TO SQL …

	Title
1	PB Datawindow
2	nested datawindows -
3	PROBLEM WITH CONNECTING DW AND…
4	Problem with data retrieval through Dat…
5	How to update a dynamic datawindow…
6	Invalid Datawindow row/column spec…

Loading Advertisement...

20080716-EE-VQP-32 - Hierarchy

1. sandeep... 97,705
2. diasroshan 65,465
3. grant300 6,748
4. mj_norwich 5,850
5. ced888 3,500
6. sdstuber 3,125
7. Hendo1... 2,880
8. Arthur_... 2,000
8. michaelst... 2,000
8. Smart_Man 2,000
8. silemone 2,000
8. molku 2,000
8. dbmullen 2,000
8. DanielWilson 2,000
8. peachkj 2,000
8. AdriendeC 2,000
17. mlmcc 1,500
17. themdx 1,500
17. johnsone 1,500
20. schwertner 1,400
21. gafoor78 1,000
21. meenasree 1,000
21. DarkoLord 1,000
21. developm... 1,000
21. rfwoolf 1,000
21. shivaspk 1,000
21. dabrat 1,000

1. diasroshan 371,288
2. sandeep... 225,737
3. Vikas_Di... 107,363
4. sajuks 95,589
5. gajender... 90,905
6. namasi_n... 75,642
7. tr1l0b1t 71,770
8. buasuwan 54,856
9. michaelst... 50,175
10. gafoor78 45,311
11. berXpert 45,216
12. Bhatti 43,019
13. hink 19,987
14. Lordain 16,588
15. batchaka... 14,007
16. BenClark 13,830
17. bluecomet 12,617
18. ced888 11,240
19. falvaro3 10,622
20. AFI 10,272
21. SylvainPo... 10,162
22. DaniPro 8,709
23. EAServer 8,680
24. mdhampton 8,433
25. loks 7,792

CONVERT PB APP FROM ASA TO SQL SERVER 2000

Asked by pemurray in PowerBuilder Programming Language

About this solution