date:20170216

restore table exported with pg_dump from within livecode?

2017-02-16 Thread Dr. Hawkins via use-livecode

I have a table that I want each customer to get as a starting point
(abbreviations for creditors)>

I've tried exporting with pg_dump for only the table

/Library/PostgreSQL/9.5/bin/pg_dump -t stockabrevs -f abrev_bkp.sql
-Udhadmin dhbk_dbtrs


I then use this within a script,

put "BEGIN TRANSACTION;" & cr & url
"file:~/Documents/dhbk/dflt_fls/abrev_bkp.sql" & cr & "END TRANSACTION;" &
cr into dcmd

revExecuteSql dbUsrDbNo, dcmd


This, however, gives me

ERROR: syntax error at or near "scum"

LINE 232: scum \N \N S f f f f the scummiest lending company under t...

^

The relevant section of the dumped file seems to be

--

-- Data for Name: stockabrevs; Type: TABLE DATA; Schema: public; Owner:
dhadmin

--


COPY stockabrevs (abrev, usr, tstmp, chrtype, unliq, disp, cont, codbt,
cd_adr, rpinterest, cname, cadr, ijkey, due, acctno, pmt, reason, prtype,
npramount, hwjc, asset, value, atype, exemption_1, exval_1, scintent,
exemption_2, exval_2, exemption_3, exval_3, arrears, pmtsleft, pmtmt,
incins, inctax, unsecprt, gsl, parentdna, dpnddna, contact, prtyp, extyp_1,
extyp_2, extyp_3, dfl_exval_1, dfl_exval_2, dfl_exval_3, dfl_pmtmt,
dfl_unsecprt, dflcrd, dflcrdchps, claimno, claimamt, pramount, dodbt,
intexpl, intent, exempt, cecfeml, srv704, srvecf, srvinc, arint, cpmtstr,
grtottrpy, othvals, arint1, armnt1, arpmt1, arstr1, conduit, dfl_arint1,
dfl_armnt1, dfl_arpmt1, dfl_arstr1, dfl_grtotdbpy, dfl_grtottrpy,
dfl_p13_value, dfl_scint1, dfl_scint2, dfl_scmnt1, dfl_scmnt2, dfl_scpmt1,
dfl_scpmt2, dfl_scstr1, dfl_scstr2, grtotdbpy, p13_value, scint1, scint2,
scmnt1, scmnt2, scpmt1, scpmt2, scstr1, scstr2, cpmtmnt, dfl_cpmtmnt,
dfl_cpmtstr, dfl_matdate, matdate, p13_pstpetpby, rate, cg_chrtype,
ck_codbt, ck_cont, ck_disp, ck_exempt, ck_gsl, ck_incins, ck_inctax,
ck_srv704, ck_srvecf, ck_srvinc, ck_unliq, dfl_p13_pstpetpby, othvals2,
setoff, dfl_pramount, totliens, dfl_totliens, dat1, dat2, leased, linnodbt,
valuetot, dfl_valuetot, dfl_linnodbt, dfl_linnumdbt, linnumdbt,
dfl_linnoast, linnoast, prothexp, prtypexp, asubtype, unstyp, unstypexp,
dat3, dat4, dbtcp, dfl_exvaltot, dfl_linnoxmp, exvaltot, linnoxmp, xmpmax,
bnfnsdr, dfl_prfpydats, dfl_totpref, paynsdr, prfpydats, prfsofa, prftyp,
prftypexp, totpref, dfl_prfpydat1, prfpydat1, prfpydat2, prfpydat3,
atypeexp, astoinfo, dfl_insbnfpmtexp, dfl_inspmtexp, dfl_linnomtr,
dfl_propszedscr, dfl_propszeval, dfl_rpinterest, dfl_value, insbnfpmtexp,
inspmtexp, linnomtr, propszedat, propszedscr, propszeval, sctypexp,
dfl_prfpmtexp, dfl_prftypexp, prfpmtexp, dfl_prftot, prftot, pardnatyps,
dfl_parlinnosec, dfl_parlinnouns, parlinnosec, parlinnouns,
dfl_paractnosec, paractnosec, dfl_paractnouns, paractnouns, setoff90,
sftyp, dat5, exlbl_1, exlbl_2, exlbl_3) FROM stdin;


And line 232 is

scum\N  \N  S   f   f   f   f
the scummiest lending company   under the bridge with the trolls\nAmes,
IA  50010   mrt1\N  \N  \nFirst mortgage on primary
residence   \N  \N  R   NRS 21.090(l)
\N  \N  \N  \N  \N  \N  f
f   800 f   \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N

\N  \N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N
\N  \N  \N  \N  \N  \N  \N  \N  \N  \N



This doesn't look right to me; I had thought that I should have a file with
CREATE and a bunch of INSERTs.

Am I using pg_dump wrong?


-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Deleting stacks on the fly

2017-02-16 Thread Sannyasin Brahmanathaswami via use-livecode

@ Jacque: I don't think it is ram after all.

FYI: on my Nexus 5 I have 1.8 GB RAM and our new app + All of Googles "widgets" 
that come preloaded take up a mere .8 GB and I have a full GB of RAM free. 
after proceeding (as we discussed off list with our team) to delete stacks when 
we move from one to another, so that only 1 or 2 are ever open in memory… I am 
pretty certain I'm not have a memory issue on this Android Device: but it still 
crashes.

I took this to HQ… I guess you all know about plugging in your android phone 
and running ./adb logcat  and then pass that over to LC support.

If you are interested  you can view it here:

http://wiki.hindu.org/uploads/siva-siva-app_adb-log.txt  # 13MB file

if you search 

Activity Manager: Process com.himalayan

You will run into all the instances of 

ActivityManager: Process com.himalayanacademy.sivasiva (pid 25473) has died

(crash/exit)


There appear to be three different "flavors" of "exited due to signal (11)  in 
that log.  I won't detail them here as I don't grok the log well enough to talk 
about it. 

Hopefully HQ will figure it out… building from 8.1.3 (RC2)

does 9 dp4 change the file format? Safe?  I could make back ups of course.  and 
test… but need to keep moving on content dev… 

 I have no recipe or rather, we do, but it seems harmless.

we "Go" from one stack to another, then after 10 milliseconds, delete the first 
one

here is the handler where the app exits on signal 11, you can  see where we 
were fiddling with 

1) just closing it, 
2) opening stack B and deleting stack A
3) Opening stack B and send a "Delete" stack A in 10 milliseconds.

All three scenarios cause android to crash and we have *lots* of open RAM. 

command portal_GoStack stackName
   -- goes to the new stack
   -- closes the current stack
   -- safely ignores if we are alrady in the new stack
   
   put the short name of this stack into oStackName
   if oStackName = stackName then return oStackName
   
   go to stack stackName
  --close stack oStackName
   -- test deleting the stacks to save on RAM
  send "portal_RemoveStack oStackName" to me in 10 milliseconds  
--   delete stack oStackName
   return oStackName
end portal_GoStack

command portal_RemoveStack stackName
if stackName <> "Siva-Siva-App" then
delete stack stackName
end if
end portal_RemoveStack


# Works perfectly well on iOS








Svasti Astu, Be Well 
Brahmanathaswami

www.himalayanacademy.com

 

On 2/14/17, 6:48 AM, "use-livecode on behalf of J. Landman Gay via 
use-livecode"  wrote:

I frequently delete stacks when memory is an issue, which is the problem 
with Swami's stack suite. I also create almost all new stacks with 
destroystack set to true for the same reason.



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: ulExtIsBlocked

2017-02-16 Thread J. Landman Gay via use-livecode

That bug might be related, yes. I can't remember now whether it only 
happened after I built a standalone, but I will pay more attention now. 
Thanks for the pointer, I wasn't sure what the error meant.



On 2/16/17 3:01 AM, Charles Warwick via use-livecode wrote:

Sounds like the tsNetLibUrl stack may have been unloaded.

Is it possible this bug is affecting you?

http://quality.livecode.com/show_bug.cgi?id=18833


On 16/02/2017 6:33 PM, J. Landman Gay via use-livecode wrote:

I keep getting this message, both in the IDE and in a standalone:

 Message execution error:
 Error description: Function: error in function handler
 Hint: ulExtIsBlocked

It's either a libURL or TSNet error, so it looks like a thing for
Charles W. Thoughts? I need a workaround.



--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Provisioning Profiles list

2017-02-16 Thread Devin Asay via use-livecode

Thanks, Panos. That’s what I needed to know.

Devin


On Feb 16, 2017, at 10:46 AM, panagiotis merakos via use-livecode 
> wrote:

Hi Devin,

If that helps, *all* the provisioning profiles are stored in
/Users//Library/MobileDevice/Provisioning Profiles/

Best,
Panos
--



On Thu, Feb 16, 2017 at 5:41 PM, Devin Asay via use-livecode <
use-livecode@lists.runrev.com> wrote:

Does anyone know how to clear out expired Provisioning Profiles from the
Standalone application settings for iOS? My option menu shows every PP that
ever existed on my system, making it difficult to choose the most current
one.

Thanks,

Devin


Devin Asay
Director
Office of Digital Humanities
Brigham Young University

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Devin Asay
Director
Office of Digital Humanities
Brigham Young University

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Provisioning Profiles list

2017-02-16 Thread panagiotis merakos via use-livecode

Hi Devin,

If that helps, *all* the provisioning profiles are stored in
/Users//Library/MobileDevice/Provisioning Profiles/

Best,
Panos
--



On Thu, Feb 16, 2017 at 5:41 PM, Devin Asay via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Does anyone know how to clear out expired Provisioning Profiles from the
> Standalone application settings for iOS? My option menu shows every PP that
> ever existed on my system, making it difficult to choose the most current
> one.
>
> Thanks,
>
> Devin
>
>
> Devin Asay
> Director
> Office of Digital Humanities
> Brigham Young University
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Provisioning Profiles list

2017-02-16 Thread Devin Asay via use-livecode

Does anyone know how to clear out expired Provisioning Profiles from the 
Standalone application settings for iOS? My option menu shows every PP that 
ever existed on my system, making it difficult to choose the most current one.

Thanks,

Devin


Devin Asay
Director
Office of Digital Humanities
Brigham Young University

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: ulExtIsBlocked

2017-02-16 Thread Charles Warwick via use-livecode


Sounds like the tsNetLibUrl stack may have been unloaded.

Is it possible this bug is affecting you?

http://quality.livecode.com/show_bug.cgi?id=18833


On 16/02/2017 6:33 PM, J. Landman Gay via use-livecode wrote:

I keep getting this message, both in the IDE and in a standalone:

 Message execution error:
 Error description: Function: error in function handler
 Hint: ulExtIsBlocked

It's either a libURL or TSNet error, so it looks like a thing for 
Charles W. Thoughts? I need a workaround.





___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

ulExtIsBlocked

2017-02-16 Thread J. Landman Gay via use-livecode


I keep getting this message, both in the IDE and in a standalone:

 Message execution error:
 Error description: Function: error in function handler
 Hint: ulExtIsBlocked

It's either a libURL or TSNet error, so it looks like a thing for 
Charles W. Thoughts? I need a workaround.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

restore table exported with pg_dump from within livecode?

Re: Deleting stacks on the fly

Re: ulExtIsBlocked

Re: Provisioning Profiles list

Re: Provisioning Profiles list

Provisioning Profiles list

Re: ulExtIsBlocked

ulExtIsBlocked

8 matches

Site Navigation

Mail list logo

Footer information