Запись входящих СМС (SMS-DELIVER) в базу данных ODBC с использованием программ NHSMS, NHDBT, NHRPLC. Необходимо указать командный файл в INI файле: commandline=sms2db.cmd

if not "%sms_type%"=="SMS-DELIVER" exit /b 0
set sql_file=%sms_sender%-%sms_senttime_year%%sms_senttime_month%^
%sms_senttime_day%%sms_senttime_hour%%sms_senttime_min%%sms_senttime_sec%.sql
set messagetext_file=%sms_sender%-%sms_senttime_year%%sms_senttime_month%^
%sms_senttime_day%%sms_senttime_hour%%sms_senttime_min%%sms_senttime_sec%.msg
echo %sms_messagetext% >%messagetext_file%
nhrplc -s:' -t:'' %messagetext_file%
nhrplc -s:"\\n" -t:'+CHR(10)+' %messagetext_file%
nhrplc -s:"\\r" -t:'+CHR(13)+' %messagetext_file%
nhrplc -s:"\\t" -t:'+CHR(9)+' %messagetext_file%
echo insert into IncomingSms (SenderPhone,SentTime,MessageText) values ^
('%sms_sender%','%sms_senttime%','sms_messagetext'); >%sql_file%
nhrplc -s:sms_messagetext -f:%messagetext_file% %sql_file%
nhdbt "Microsoft dBase driver (*.dbf)" "DBQ=." %sql_file%
del %sql_file% & del %messagetext_file%