Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
2
Language / SMS Text Notifications
« on: September 01, 2022, 10:17:22 AM »
Is there a way to send text notifications via SMS using pvx?
3
Programming / Determining numbers used in an ASCII sequence.
« on: June 23, 2022, 11:29:06 AM »
Trying to find the number of slots used between a starting and ending alphanumeric number, i.e. the number of slots used between A000ZZ and A0010F. Positions 4 & 6 can be 0-Z, position 5 A-Z (with the exclusion of :;<=>?@)
)
)
4
Programming / Need leading zeros in excel
« on: April 27, 2022, 09:28:16 AM »
I am outputting my line in the following IOLIST but I need to show the leading zeroes, especially for PN$:[STR(",")]. Line 55040 works great except leading zeroes are being suppressed when I view the output in Excel.
55040 LINE1:IOLIST PRC$:[STR(",")],PN$:[STR(",")],DUPRESIND$:[STR(",")],ONEPRIC
55040:E$[2]:[STR(",")],ONEPRICE$[3]:[STR(",")],ONEPRICE$[4]:[STR(",")],ONEPRICE
55040:$[5]:[STR(",")],ONEPRICE$[6]:[STR(",")],ONEPRICE$[7]:[STR(",")],ONEPRICE$
55040:[8]:[STR(",")],ONEPRICE$[9]:[STR(",")],ONEPRICE$[10]:[STR(",")],ONEPRICE$
55040:[11]:[STR(",")],ONEPRICE$[12]:[STR(",")],ONEPRICE$[13]:[STR(",")],ONEPRIC
55040:E$[14]:[STR(",")],ONEPRICE$[15]:[STR(",")],ONEPRICE$[16]:[STR(",")],ONEPR
55040:ICE$[17]:[STR(",")],ONEPRICE$[18]:[STR(",")],ONEPRICE$[19]:[STR(",")]
55040 LINE1:IOLIST PRC$:[STR(",")],PN$:[STR(",")],DUPRESIND$:[STR(",")],ONEPRIC
55040:E$[2]:[STR(",")],ONEPRICE$[3]:[STR(",")],ONEPRICE$[4]:[STR(",")],ONEPRICE
55040:$[5]:[STR(",")],ONEPRICE$[6]:[STR(",")],ONEPRICE$[7]:[STR(",")],ONEPRICE$
55040:[8]:[STR(",")],ONEPRICE$[9]:[STR(",")],ONEPRICE$[10]:[STR(",")],ONEPRICE$
55040:[11]:[STR(",")],ONEPRICE$[12]:[STR(",")],ONEPRICE$[13]:[STR(",")],ONEPRIC
55040:E$[14]:[STR(",")],ONEPRICE$[15]:[STR(",")],ONEPRICE$[16]:[STR(",")],ONEPR
55040:ICE$[17]:[STR(",")],ONEPRICE$[18]:[STR(",")],ONEPRICE$[19]:[STR(",")]
6
Programming / Re: ENTER using default values
« on: August 25, 2021, 03:51:27 PM »
CALL "programname", A$,B$,C$,D$,E$.F$
7
Programming / ENTER using default values
« on: August 25, 2021, 03:42:42 PM »
0030 ENTER IN0$,IZ$="",ICANCEL$="N",IUPDOPT$="ALL",ISTOREID$="1"
When I step through after line 0030, ICANCEL$, IUPDOPT$ and ISTOREID$ show null.
When I step through after line 0030, ICANCEL$, IUPDOPT$ and ISTOREID$ show null.
8
Programming / Re: OPEN STATEMENT AND IOLIST
« on: July 20, 2021, 02:10:33 PM »
Thank you, Devon. I'm new to pvx but I have been programming in BBx for many years.
9
Programming / OPEN STATEMENT AND IOLIST
« on: July 20, 2021, 12:25:05 PM »
I have code to OPEN and SELECT records from a file M1TEMP. I want to print out the first 2 fields but get no data.
1340 OPEN:
1360 LET M1TEMP=%FILEOBJ'OPEN("M1TEMP")
2000 ! ^1000,20
2020 MAINLINE:
2080 SELECT * FROM "M1TEMP" BEGIN "" END $FF$
2140 PRINT M1TEMP.CUSTOMERNUMBER$," ",M1TEMP.SEQUENCENUMBER$; INPUT *
2160 NEXT RECORD
1340 OPEN:
1360 LET M1TEMP=%FILEOBJ'OPEN("M1TEMP")
2000 ! ^1000,20
2020 MAINLINE:
2080 SELECT * FROM "M1TEMP" BEGIN "" END $FF$
2140 PRINT M1TEMP.CUSTOMERNUMBER$," ",M1TEMP.SEQUENCENUMBER$; INPUT *
2160 NEXT RECORD
10
Programming / Re: Commas and Quotes embedded in data for PRINT to csv file
« on: July 16, 2021, 05:52:03 PM »
Thank you for your help. Your suggestion work beautifully.
11
Programming / Commas and Quotes embedded in data for PRINT to csv file
« on: July 09, 2021, 04:57:31 PM »
I have data that needs to be in its own column. Some fields have a leading double quote (") and some have embedded commas. Here's my print statement:
3100 LET QO$=$22$,SQO$=$22$+$2C$+$3D$+$22$
QO$ is "
SQO$ is ",="
3513 IF MID(SMCROSS$,1,1)=$22$ THEN PRINT (ONEPRICEDUMP)QO$,SMPRC$,"="+CQO$,SMC
3513:ROSS$,SQO$,DUPRESIND$,SQO$, ELSE PRINT (ONEPRICEDUMP)QO$,SMPRC$,SQO$,SMCRO
3513:SS$,SQO$,DUPRESIND$,SQO$,
My goal is to at least show the data with a leading double quote as it is.
3100 LET QO$=$22$,SQO$=$22$+$2C$+$3D$+$22$
QO$ is "
SQO$ is ",="
3513 IF MID(SMCROSS$,1,1)=$22$ THEN PRINT (ONEPRICEDUMP)QO$,SMPRC$,"="+CQO$,SMC
3513:ROSS$,SQO$,DUPRESIND$,SQO$, ELSE PRINT (ONEPRICEDUMP)QO$,SMPRC$,SQO$,SMCRO
3513:SS$,SQO$,DUPRESIND$,SQO$,
My goal is to at least show the data with a leading double quote as it is.
Pages: [1]